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
Q. 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.
- Both Y and Z are in BCNF
- Decomposition of X into Y and Z is dependency preserving and lossless
Which of the above statements is/are correct?
(A) Both I and II
(B) I only
(C) II only
(D) Neither I nor II
Ans: II only