Consider the following instance of a relation District – Which district names…

PYQ RPSC Programmer 2024Modified — slightly modified from the official paper; see the solution

Consider the following instance of a relation District –

image.png

Which district names will be returned by the following relational algebra expression?
πₙₐₘₑ (σₙₐₘₑ≠"AJ" (District)) − [πₙₐₘₑ (σₚₒₚᵤₗₐₜᵢₒₙ>5 (District)) ∩ πₙₐₘₑ (σₙₐₘₑ="AJ" (District))]

  1. A.

    JA,MM

  2. B.

    JA

  3. C.

    JA,AJ

  4. D.

    AJ

  5. E.

    Question not attempted

Attempted by 368 students.

Sign up free to check your answer

Sign up free

Explore the full course: Rpsc Programmer

Loading lesson…