All the following statements about intersection tables are true except?
A)Intersection tables remove many-to-many relationships.
B)Only one field in an intersect table is needed to uniquely identify a record.
C)An intersection table's primary key is a composite key.
D)The primary key for the intersection table includes the foreign keys of the tables.

Question

Quizplus · Accepted Answer

A many-to-many relationship requires an intersection table to break it down into two one-to-many relationships, each with a unique primary key. Therefore, intersection tables actually create a many-to-many relationship, not remove it. The primary key of an intersection table is a composite key made up of the foreign keys of the two tables it intersects.

All the Following Statements About Intersection Tables Are True Except