Consider a schema R(A,B,C,D) and functional dependencies A->B and C->D. Then…

PYQ GATE 2001

Consider a schema R(A,B,C,D) and functional dependencies A->B and C->D. Then the decomposition of R into R1(AB) and R2(CD) is

  1. A.

    dependency preserving and lossless join

  2. B.

    lossless join but not dependency preserving

  3. C.

    dependency preserving but not lossless join

  4. D.

    not dependency preserving and not lossless join

Attempted by 473 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…