When increasing cardinalities from 1:N to N:M,which of the following steps 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 the cardinality from 1:N to N:M, we need to create an intersection table to represent the many-to-many relationship. Then we need to populate the intersection table with the appropriate data. Finally, we need to drop the old foreign key from the original table to remove the one-to-many relationship. Therefore, all three steps (A,B, and C) are included in the process.

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