Consider a schema R(ABCDEFGHIJK) with the following functional dependencies: F…

Consider a schema R(ABCDEFGHIJK) with the following functional dependencies:

F = {AB -> C, A -> DE, B -> F, F -> GH, D -> IJK}

The decomposition of R into R1(ABCD), R2(DE), R3(BFGH), and R4(DIJK) is:

  1. A.

    Lossless join & dependency preserving.

  2. B.

    Lossless join & dependency not preserving.

  3. C.

    Lossy join and dependency not preserving.

  4. D.

    Lossy join and dependency preserving.

Attempted by 49 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…