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

PYQ UGC NET 2012

Consider a schema R(A, B, C, D) and functional dependencies A → B and C → D. Then the decomposition R1(A, B) and R2(C, D) is

  1. A.

    Dependency preserving but not lossless join

  2. B.

    Dependency preserving and lossless join

  3. C.

    Lossless join but not dependency preserving

  4. D.

    Lossless join

Attempted by 194 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…