Consider a relational database schema with two relations 𝑅(𝑃,𝑄) and…

GATE Β· 2026 Β· CS Β· Set 1 Β· Computer Science & IT

Consider a relational database schema with two relations 𝑅(𝑃,𝑄) and 𝑆(𝑋,π‘Œ). Let 𝐸 = {βŸ¨π‘’βŸ©βˆ£βˆƒπ‘£ βˆƒπ‘€ βŸ¨π‘’,π‘£βŸ©βˆˆπ‘… ∧ βŸ¨π‘£,π‘€βŸ© βˆˆπ‘†} be a tuple relational calculus expression.

Which one of the following relational algebraic expressions is equivalent to 𝐸 ?

  1. A.

    Ξ P(R β‹ˆR.P = S.X S)

  2. B.

    Ξ P(S β‹ˆS.X = R.Q R)

  3. C.

    Ξ P(R β‹ˆR.P = S.Y S)

  4. D.

    Ξ P(S β‹ˆS.Y = R.Q R)

Attempted by 220 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…