GATEverse Practice, past papers & mock tests
GATE 2019
Database ManagementDatabase Design: Functional Dependencies and NormalizationhardMCQ2 marks
Let the set of functional dependencies F = { QR -> S, R -> P, S -> Q } hold on relation schema X(P, Q, R, S). X is not in BCNF. Suppose X is decomposed into Y(P, R) and Z(Q, R, S). Consider the statements: I. Both Y and Z are in BCNF II. Decomposition of X into Y and Z is dependency preserving and lossless. Which of the above statements is/are correct?
Save your progress

Related Database Management PYQs