Consider a relation R(A,B,C,D,E,F,G) with a set of functional dependencies:…

Consider a relation R(A,B,C,D,E,F,G) with a set of functional dependencies:

F={AD→BF, CD→EGC, BD→F, E→D, F→C, D→F}

The relation R is decomposed into the following two relations after finding the minimal cover for the above set of functional dependencies: R1(A,B,C,D,E), R2(A,D,F,G)

Use the functional dependencies in the minimal cover to determine the nature of this decomposition and find the correct statement below:

  1. A.

    Decomposition is lossless and dependency preserving

  2. B.

    Decomposition is lossy and dependency preserving

  3. C.

    Decomposition is lossy and not dependency preserving

  4. D.

    Decomposition is lossless and not dependency preserving

Attempted by 45 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…