The primary key for M:N relationship tables
A)is a single attribute.
B)always consists of two attributes.
C)is the primary key of the most important entity linked to that relationship.
D)does not exist.Many-to-many relationship tables only use foreign keys.

Question

Quizplus · Accepted Answer

The primary key for M:N relationship tables always consists of two attributes, each of which is a foreign key referencing the primary keys of the entities involved in the relationship. This is because an M:N relationship represents a many-to-many association between two entities, which requires a separate table to store the relationships between them. The primary key of this relationship table must uniquely identify each instance of the relationship, which is accomplished by combining the foreign keys of the two entities involved.

The Primary Key for M:N Relationship Tables