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

ISRO Scientist/Engineer SC 2014

Consider the schema R(A, B, C, D) and the functional dependencies A->B and C->D. If the decomposition is made as R1(A,B) and R2(C,D), then which of the following is TRUE?

  1. A.

    Preserves dependency but cannot perform lossless join

  2. B.

    Preserves dependency and performs lossless join

  3. C.

    Does not preserve dependency and cannot perform lossless join

  4. D.

    Does not preserve dependency but performs lossless join

Attempted by 1073 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…