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 become foreign keys in a new relation C.
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.
E) none of the above should be done.

Question

Quizplus · Accepted Answer

An associative entity is used to represent a many-to-many relationship between two entities. In this case, a separate relation (table) is created, and its primary key is typically a composite key consisting of the primary keys of the two entities involved in the relationship.

If an Associative Entity Exists, Then