When increasing cardinalities from 1:N to N:M,we basically create a new intersection table,fill it with data and drop the old foreign key.

Question

Quizplus · Accepted Answer

When transitioning from a 1:N (one-to-many) relationship to an N:M (many-to-many) relationship, a new intersection (or join) table is created to manage the relationships between the two entities. This table contains foreign keys that reference the primary keys of the two entities it connects. The original foreign key in the entity that previously managed the 1:N relationship is no longer necessary and is typically removed, as the relationship management is now handled by the intersection table.

When Increasing Cardinalities from 1:N to N:M,we Basically Create a New