Let the set of functional dependencies F = {QR → S, R → P, S → Q} hold on a…
GATE · 2019 · CS · Computer Science & IT
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?
- A.
I only
- B.
Neither I nor II
- C.
II only
- D.
Both I and II
Attempted by 277 students.
Sign up free to check your answer
Sign up freeLoading lesson…