To represent a multivalued attribute in an E-R model,________.
A)create a new ID-dependent entity with a 1:N relationship
B)create a new weak,but not ID-dependent entity with a 1:N relationship
C)create a new strong entity with a 1:1 relationship
D)create a new ID-dependent entity with a 1:1 relationship

Question

Quizplus · Accepted Answer

Creating a new ID-dependent entity with a 1:N relationship is the best choice for representing a multivalued attribute in an E-R model. This new entity will have a relationship with the original entity that represents the multivalued attribute, with each instance of the new entity representing one value of the attribute. This allows for efficient storage and retrieval of the data.

To Represent a Multivalued Attribute in an E-R Model,________