Project ForgeSign up free
Database Management Systems
Relational Model & ER Basics
GATE 2008
Hard

(Same ER diagram as before — M(M1 key,M2,M3) —R1(many:one)→ P(P1 key,P2) ←R2(identifying)— weak entity N(N1 partial key,N2).) Which of the following is a correct attribute set for one of the tables for the correct (minimum, 3-table) answer to the previous question?

  • {M1, M2, M3, P1}
  • B{M1, P1, N1, N2}
  • C{M1, P1, N1}
  • D{M1, P1}

Explanation

The M table, after merging in the many-to-one relationship R1, has M's own 3 attributes (M1, M2, M3) plus a foreign key P1 referencing P — exactly {M1, M2, M3, P1}. The other options mix attributes across the wrong tables or are incomplete.

Source: GATE CS 2008 (2008)

This question is part of a 15-day revision cycle — sign in and Project Forge will bring it back the day before you'd forget it.

Start revising free