Consider a schema R(A,B,C,D) and functional dependencies A->B and C->D. Then…
GATE · 2001 · CS · Question 1 subparts
Consider a schema R(A,B,C,D) and functional dependencies A->B and C->D. Then the decomposition of R into R1(AB) and R2(CD) is
- A.
dependency preserving and lossless join
- B.
lossless join but not dependency preserving
- C.
dependency preserving but not lossless join
- D.
not dependency preserving and not lossless join
Attempted by 344 students.
Sign up free to check your answer
Sign up freeLoading lesson…