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.

  1. Both Y and Z are in BCNF
  2. 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

We will be happy to hear your thoughts

Leave a reply

Gkseries.com
Logo
Register New Account