Which of the following is the correct technique for representing a M:N relationship using the relational model?
A) An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation.
B) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
C) An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
D) The key from either relation is placed as a foreign key in the other relation.
E) None of the above

Question

Quizplus · Accepted Answer

The correct technique for representing a M:N relationship using the relational model is to create an intersection relation, and the keys of both parent entities are placed as a composite key in the intersection relation. This ensures that each possible combination of the two parent entities is unique and can be properly related to each other. Choices A, B, and D do not fully capture the complexities of a M:N relationship and may result in data integrity issues.

Which of the Following Is the Correct Technique for Representing