In many-to-many relationships between strong entities in a relational database design,which of the following is not true?
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 relationships from the intersection table to the parent tables are identifying relationships
D)The maximum cardinality to the intersection table is always N

Question

Quizplus · Accepted Answer

In a many-to-many relationship between strong entities, the intersection table is ID-dependent on both of the parents, not just one. This means it typically contains foreign keys referencing the primary keys of both parent tables, establishing identifying relationships with both. The maximum cardinality to the intersection table is indeed always N, reflecting the many-to-many nature of the relationship.

In Many-To-Many Relationships Between Strong Entities in a Relational Database