When using an REA diagram to develop a database,many-to-many relationships must be
A) broken into multiple one-to-one relationships.
B) combined into a single one-to-one relationship.
C) combined into a one-to-many relationship.
D) broken into multiple one-to-many relationships.

Question

Quizplus · Accepted Answer

Many-to-many relationships between two entities in an REA diagram require the creation of a new table that includes the primary keys of both entities, acting as foreign keys. So, the many-to-many relationships must be broken down into multiple one-to-many relationships between each of the original entities and their respective primary keys in the new table. Therefore, option D is the best choice.

When Using an REA Diagram to Develop a Database,many-To-Many Relationships