Consider a schema R(A, B, C, D) with the following functional dependencies: A…
Consider a schema R(A, B, C, D) with the following functional dependencies:
A → B
B → C
C → D
D → B
The decomposition of R into R1(A, B), R2(B, C) and R3(B, D) 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 86 students.
Sign up free to check your answer
Sign up freeLoading lesson…

