Let M and N be two entities in an E-R diagram with simple single value…
2017
Let M and N be two entities in an E-R diagram with simple single value attributes. R1 and R2 are two relationship between M and N, where as
R1 is one-to-many and R2 is many-to-many.
The minimum number of tables required to represent M, N, R1 and R2 in the relational model are _______.
- A.
4
- B.
6
- C.
7
- D.
3
Attempted by 583 students.
Show answer & explanation
Correct answer: D
Answer: 3
One table for entity M.
One table for entity N.
One table for the many-to-many relationship R2 (a junction table with foreign keys to M and N).
Note: The one-to-many relationship R1 is implemented by adding a foreign key to the table on the many side, so it does not require a separate table. Because attributes are simple and single-valued, no extra tables are needed for attributes.
A video solution is available for this question — log in and enroll to watch it.