If an associative entity exists,then:
A)a separate relation C is created;the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship
B)the primary keys of relation A and relation B are designated as functionally dependent attributes
C)secondary keys are used to establish the relationship
D)place the primary key of either entity in the relation for the other entity or do this for both entities

Question

Quizplus · Accepted Answer

An associative entity represents a many-to-many relationship between two entities, and thus requires a separate relation C to be created. The primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship. This approach helps to establish a clear and efficient relationship between the entities.

If an Associative Entity Exists,then