In many-to-many relationships in a relational database design,________.
A) the intersection table is ID-dependent on one of the parents
B) the intersection table is ID-dependent on both of the parents
C) the minimum cardinality from the intersection table to the parents is always M
D) Both A and B
E) Both B and C

Question

Quizplus · Accepted Answer

In many-to-many relationships, an intersection (or join) table is used to link the two tables involved in the relationship. This intersection table is ID-dependent on both of the parent tables because it typically contains foreign keys that reference the primary keys of each parent table. Additionally, the minimum cardinality from the intersection table to the parents is always many (M), as the purpose of the intersection table is to facilitate a many-to-many relationship.

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