Consider relation R(A,B,C,D) with functional dependencies: A -> B, C -> D, AD…

Consider relation R(A,B,C,D) with functional dependencies: A -> B, C -> D, AD -> C, BC -> A Suppose we decompose R into Boyce-Codd Normal Form (BCNF). Which of the following schemas could not be in the result of the decomposition?

  1. A.

    AB

  2. B.

    ACD

  3. C.

    CD

  4. D.

    AC

Attempted by 112 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…