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:
- 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 45 students.
Sign up free to check your answer
Sign up freeLoading lesson…

