The key for an intersection table is always the combination of the keys of the parent entities.

Question

Quizplus · Accepted Answer

An intersection table's primary key is made up of the combination of the primary keys of the two parent entities it connects. This is because the purpose of an intersection table is to represent the many-to-many relationship between the two parent entities, and the combination of their primary keys is the unique identifier for each relationship instance in the intersection table.

The Key for an Intersection Table Is Always the Combination