When increasing cardinalities from 1:N to N:M,which of the following steps is/are included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )
A)Create an intersection table
B)Populate the intersection table
C)Drop the old foreign key
D)A and B
E)A,B,and C

Question

Quizplus · Accepted Answer

When increasing cardinalities from 1:N to N:M, both steps A (create an intersection table) and B (populate the intersection table) are necessary to establish the many-to-many relationship. Additionally, step C (drop the old foreign key) is needed to remove the previous one-to-many relationship. Therefore, the correct choice is E, which includes all three steps.

When Increasing Cardinalities from 1:N to N:M,which of the Following