The primary key of the relation added to accomplish the many-to-many relationship ____.
A) must contain at least three attributes
B) must contain at least four attributes
C) is the primary key of one of the two relations involved in the many-to-many relationship
D) does not involve the primary keys of either of the two relations involved in the many-to-many relationship
E) is the combination of the primary keys of the two relations involved in the many-to-many relationship plus possible additional attributes

Question

Quizplus · Accepted Answer

The primary key of the relation added in a many-to-many relationship should be the combination of the primary keys of the two relations involved in the relationship, plus any additional attributes necessary for the relationship. This new primary key then serves as the link between the two original relations.

The Primary Key of the Relation Added to Accomplish the Many-To-Many