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 tables are joined into a composite key
E)C and D

Question

Quizplus · Accepted Answer

In a many-to-many relationship, the keys of both tables are placed in a third table, which is called a junction table. The junction table has two foreign keys, one from each of the parent tables. This allows each row in the junction table to represent a relationship between a row in the first parent table and a row in the second parent table.

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