Let r be a relation instance with schema R = (A, B, C, D). We define r₁ = Π…
GATE · 2005 · CS
Let r be a relation instance with schema R = (A, B, C, D). We define r₁ = Π A,B,C (r) and r₂ = Π A,D (r). Let s = r₁ * r₂ where * denotes natural join. Given that the decomposition of r into r₁ and r₂ is lossy, which one of the following is TRUE?
- A.
s ⊂ r
- B.
r ∪ s = r
- C.
r ⊂ s
- D.
r * s = s
Attempted by 268 students.
Sign up free to check your answer
Sign up freeLoading lesson…