Consider a schema R(A, B, C, D) with the following functional dependencies: A…

Consider a schema R(A, B, C, D) with the following functional dependencies:

  • A → B

  • B → C

  • C → D

  • D → B

The decomposition of R into R1(A, B), R2(B, C) and R3(B, D) 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 86 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…