Consider the following ER diagram. Minimum number of tables needed to…
2025
Consider the following ER diagram.
Minimum number of tables needed to represent M, N, P, R1, R2 is
- A.
2
- B.
3
- C.
4
- D.
5
Attempted by 215 students.
Show answer & explanation
Correct answer: B
To minimize redundancy without losing any structural constraints, we get the following tables:
Table 1 (for P):
P(P1, P2)Table 2 (for M and R1):
M(M1, M2, M3, P1)(where P1 is a foreign key referencing P)Table 3 (for N and R2):
N(P1, N1, N2)(where P1 is a foreign key referencing P)
Conclusion
The minimum number of tables needed to represent the entire schema is 3.