Assume that all attributes are of integer type and make no assumptions about…

Assume that all attributes are of integer type and make no assumptions about keys. Which of the following is a valid equality of relational algebra queries on relations R(A, B, C) and S(B, C, D)?

  1. A.

    π₍A, B₎(R) = π₍A₎(R) × π₍B₎(R)

  2. B.

    π₍A, D₎(R ⋈ S) = π₍A₎(R) ⋈ (π₍D₎(S))

  3. C.

    σ₍R.B = S.B and R.C = S.C₎ (R × S) = R ⋈ S

  4. D.

    None of the above

Attempted by 185 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…