Consider the schema R(A, B, C, D) and the functional dependencies A->B and…
ISRO Scientist/Engineer SC 2014
Consider the schema R(A, B, C, D) and the functional dependencies A->B and C->D. If the decomposition is made as R1(A,B) and R2(C,D), then which of the following is TRUE?
- A.
Preserves dependency but cannot perform lossless join
- B.
Preserves dependency and performs lossless join
- C.
Does not preserve dependency and cannot perform lossless join
- D.
Does not preserve dependency but performs lossless join
Attempted by 1073 students.
Sign up free to check your answer
Sign up freeLoading lesson…

