In many-to-many relationships in a relational database design,________.
A)the key of the child is placed as a foreign key into the parent
B)the key of the parent is placed as a foreign key into the child
C)the keys of both tables are placed in a third table
D)the keys of both entity tables are placed in each other

Question

Quizplus · Accepted Answer

In many-to-many relationships, a third or intermediate/intersection table is created to hold the keys of both tables. This table allows for a link between the two tables and eliminates the need for duplicating data or creating multiple foreign keys. Therefore, the correct choice is C.

In Many-To-Many Relationships in a Relational Database Design,________