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.
- A.
Decomposition is lossless and dependency preserving
- B.
Decomposition is lossy and dependency preserving
- C.
Decomposition is lossy and not dependency preserving
- D.
Decomposition is lossless and not dependency preserving
Attempted by 43 students.
Sign up free to check your answer
Sign up freeLoading lesson…

