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?

  1. A.

    s ⊂ r

  2. B.

    r ∪ s = r

  3. C.

    r ⊂ s

  4. D.

    r * s = s

Attempted by 268 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…