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) none of the above.

Question

Quizplus · Accepted Answer

When a regular entity type contains a multivalued attribute, it is best to create two new relations. One relation will contain the primary key of the entity type along with the other attributes, while the other relation will contain the multivalued attribute along with the primary key of the entity type as a foreign key. This helps to avoid redundancy and reduce data inconsistencies.

When a Regular Entity Type Contains a Multivalued Attribute,one Must