Consider a relation R(ABCDE) with the FD set F = {A→BC, CD→E, B→D, E→A}…

Consider a relation R(ABCDE) with the FD set

F = {A→BC, CD→E, B→D, E→A} decomposed into D={ABC, CDE}. Which of the following is true regarding the decomposition D?

  1. A.

    It is lossless but not dependency preserving

  2. B.

    It is lossy but dependency preserving

  3. C.

    It is neither lossless nor dependency preserving

  4. D.

    It is both lossless and dependency preserving

Attempted by 72 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…