Let R1 (A, B, C) and R2 (D, E) be two relation schema, where the primary keys…

PYQ GATE 2004

Let R1 (A, B, C) and R2 (D, E) be two relation schema, where the primary keys are shown underlined, and let C be a foreign key in R1 referring to R2. Suppose there is no violation of the above referential integrity constraint in the corresponding relation instances r1 and r2. Which one of the following relational algebra expressions would necessarily produce an empty relation ?
GATECS2004

  1. A.

    π_D(r₂) − π_C(r₁)

  2. B.

    π_C(r₁) − π_D(r₂)

  3. C.

    π_D(r₁ ⋈_{C≠D} r₂)

  4. D.

    π_C(r₁ ⋈_{C=D} r₂)

Attempted by 458 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…