Suppose R1(A, B) and R2(C, D) are two relation schemas. Let r1 and r2 be the…

GATE · 2012 · CS · Computer Science & IT

Suppose R1(A, B) and R2(C, D) are two relation schemas. Let r1 and r2 be the corresponding relation instances. B is a foreign key that refers to C in R2. If data in r1 and r2 satisfy referential integrity constraints, which of the following is ALWAYS TRUE?

  1. A.

    ΠB(r1)−ΠC(r2)=∅\Pi_{B}(r_{1})- \Pi_{C}(r_{2})= \varnothing

  2. B.

    ΠC(r2)−ΠB(r1)=∅\Pi_{C}(r_{2})- \Pi_{B}(r_{1})= \varnothing

  3. C.

    ΠB(r1)=ΠC(r2)\Pi_{B}(r_{1}) = \Pi_{C}(r_{2})

  4. D.

    ΠB(r1)−ΠC(r2)≠∅\Pi_{B}(r_{1}) - \Pi_{C}(r_{2}) \neq \varnothing

Attempted by 556 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…