Consider relation R(A,B,C,D,E,F,G) with functional dependencies F = {AD→BF,…

Consider relation R(A,B,C,D,E,F,G) with functional dependencies F = {AD→BF, CD→EGC, BD→F, E→D, F→C, D→F}. After finding the minimal cover, R is decomposed into R1(A,B,C,D,E) and R2(A,D,F,G). Determine whether this decomposition is lossless and dependency preserving.

  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 43 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…