When a regular entity type contains a multivalued attribute, one must:
A) create a single relation with multiple lines for each instance of the multivalued attribute.
B) create two new relations, one containing the multivalued attribute.
C) create two new relations, both containing the multivalued attribute.
D) delete the relation and start over.

Question

Quizplus · Accepted Answer

To handle multivalued attributes, you create a separate relation for the multivalued attribute and establish a relationship between the original entity and this new relation.

When a Regular Entity Type Contains a Multivalued Attribute, One