For a binary many-to-many relationship existing between entity types A and B:
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) Entity A and B are merged into one.

Question

Quizplus · Accepted Answer

In a binary many-to-many relationship, a separate relation (often called a junction table or associative entity) is created. The primary key of this new relation is typically a composite key consisting of the primary keys from each of the two entities involved in the relationship.

For a Binary Many-To-Many Relationship Existing Between Entity Types a and B