What step should be taken when designing a relational database when a many-to-many relationships exists?
A)No action is needed.
B)Create a boundary event.
C)Create two one-to-many relationships.
D)Recreate the foreign key.

Question

Quizplus · Accepted Answer

When a many-to-many relationship exists, it cannot be directly represented in a relational database. To solve this problem, we need to create two one-to-many relationships with an intermediate table between them. The intermediate table will have foreign keys referencing the primary keys of the two tables involved in the many-to-many relationship. This intermediate table will serve as a junction table that will contain a list of all the relationships between the two tables.

What Step Should Be Taken When Designing a Relational Database