An intersection table transforms a many-to-many relationship to two one-to-many relationships.

Question

Quizplus · Accepted Answer

An intersection table is commonly used in database design to resolve many-to-many relationships between two entities. It transforms the many-to-many relationship into two one-to-many relationships, by creating a new table that stores the primary keys of the two entities as foreign keys. This approach allows for efficient querying and data retrieval, as well as maintaining data integrity and reducing redundancy in the database schema. Therefore, the statement is true.

An Intersection Table Transforms a Many-To-Many Relationship to Two One-To-Many