Many-to-many relationships must be converted to one-to-many relationships through intersection tables.

Name: Many-to-many relationships must be converted to one-to-many relationships through intersection tables.
Brand: Quizplus
Rating: 4.9 (28 reviews)

Question

Quizplus · Accepted Answer

In database design, many-to-many relationships between tables are typically resolved by creating an intersection (or junction) table, which breaks down the many-to-many relationship into two one-to-many relationships, thereby maintaining referential integrity and facilitating queries.

Many-To-Many Relationships Must Be Converted to One-To-Many Relationships Through Intersection