GATE Computer Science (CS) 2019 Solved Papers

© examsiri.com
Question : 42 of 65
 
Marks: +1, -0
Let the set of functional dependencies F= {QR→S,R→P,S→Q} hold on a relation schema X=( PQRS ).X is not in BCNF. Suppose X is decomposed into two schemas Y and Z, where Y=(PR) and Z=(QRS). Consider the two statements given below.
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?
Go to Question: