Consider a relation R(A,B,C) with the MVD A↠B. Which of the following…

Consider a relation R(A,B,C) with the MVD A↠B. Which of the following decompositions is guaranteed to be a lossless join?

  1. A.

    R into R1​(A,B) and R2​(A,C)

  2. B.

    R into R1​(A,B,C) and R2​(B,C)

  3. C.

    R into R1​(A,B) and R2​(B,C)

  4. D.

    None

Attempted by 440 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…