The two primary keys representing the entities in the many-to-many relationship will always serve as the primary key in the additional relation representing the many-to-many relationship.

Question

Quizplus · Accepted Answer

The additional relation representing the many-to-many relationship will have its own primary key, separate from the primary keys representing the entities in the relationship. This primary key may be a composite key made up of the two primary keys representing the entities, but it is not the same thing as those keys.

The Two Primary Keys Representing the Entities in the Many-To-Many