Consider a schema R(W,X,Y,Z) and functional dependencies W->X and Y->Z. Then…
Consider a schema R(W,X,Y,Z) and functional dependencies W->X and Y->Z.
Then the decomposition of R into R1(WX) and R2(YZ) 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 469 students.
Sign up free to check your answer
Sign up freeLoading lesson…

