Consider the relations \(R(A, B)\) and \(S(B, C)\) and the following four…

UGC NET 2016

Consider the relations R(A,B)R(A, B) and S(B,C)S(B, C) and the following four relational algebra queries over R and S :

I. πA,B(R⋈S)\pi_{A, B} (R \bowtie S)

II. R⋈πB(S)R \bowtie \pi_B(S)

III. R∩(πA(R)×πB(S))R \cap (\pi_A(R) \times \pi_B (S))

IV. ΠA,R.B(R×S)\Pi_{A,R.B} (R \times S) where R⋅BR⋅B refers to the column B in table R.

One can determine that :

  1. A.

    I, III and IV are the same query.

  2. B.

    II, III and IV are the same query.

  3. C.

    I, II and IV are the same query.

  4. D.

    I, II and III are the same query.

Attempted by 132 students.

Sign up free to check your answer

Sign up free

Explore the full course: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…