Question
Which of the following is the correct technique for representing a N:M relationship using the relational model? An intersection relation is created with a surrogate
Which of the following is the correct technique for representing a N:M relationship using the relational model?
An intersection relation is created with a surrogate key, which is placed in each of the parent entities. | ||
The key from either relation is placed as a foreign key in the other relation. | ||
An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation. | ||
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. | ||
None of the above |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started