The GATE Grind

GATE 2008 CS – Question 68

Databases · Relational Model: Relational Algebra, Tuple Calculus, SQL · 2 marks · Multiple choice

Relations R(P, Q, R1, R2, R3), S(P, Q, S1, S2) both have key {P, Q}. Which queries are equivalent?

I. $\pi_P(R\bowtie S)$

II. $\pi_P(R)\bowtie\pi_P(S)$

III. $\pi_P(\pi_{P,Q}(R)\cap\pi_{P,Q}(S))$

IV. $\pi_P(\pi_{P,Q}(R)-(\pi_{P,Q}(R)-\pi_{P,Q}(S)))$

  1. Only I and II
  2. Only I and III
  3. Only I, II and III
  4. Only I, III and IV

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (D) Only I, III and IV

Explanation

We are sorry we couldn't write detailed soluition for this, we are working on it!, please consider asking your own AI, its just 2-3 clicks with very minimum effort

More Relational Model: Relational Algebra, Tuple Calculus, SQL questions

All Relational Model: Relational Algebra, Tuple Calculus, SQL questions →