Consider a relation R(A, B, C) with functional dependencies {AB,BC,CB}. The…

Consider a relation R(A, B, C) with functional dependencies {AB,BC,CB}. The relation R is decomposed in R1(A, C) and R2(A, B). Which of the following options is CORRECT about R?

  1. A.

    lossless and dependency preserving

  2. B.

    lossy but dependency preserving

  3. C.

    lossless but not dependency preserving

  4. D.

    lossy and not dependency preserving

Attempted by 339 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…