A table that links two tables that have a many-to-many relationship is often called a(n):
A) derived table.
B) intersection relation.
C) foreign table.
D) entity-relationship table.
E) derived relation.

Question

Quizplus · Accepted Answer

A table that links two tables with a many-to-many relationship is called an intersection table or junction table. It contains foreign keys that reference the primary keys in the other two tables and maps or connects the records between the two tables. The intersection table eliminates the need for repeating groups and supports referential integrity constraints, which ensure that only valid combinations of records are allowed in the related tables. Other names for an intersection table include associate, bridge, or joining table.

A Table That Links Two Tables That Have a Many-To-Many