Consider the following relations P(X,Y,Z),Q(X,Y,T) and R(Y,V). P X Y Z X1 Y1 Z1 X1 Y1 Z2 X2 Y2 Z2 X2 Y4 Z4 Q X Y T X2 Y1 2 X1 Y2 5 X1 Y1 6 X3 Y3 1 R Y V Y1 V1 Y3 V2 Y2 V3 Y2 V2 How many tuples will be returned by the following relational algebra query? \Pi_{x}(\sigma_{(P, Y=R . Y ∧ R . V=v 2)}(P \times R))-\Pi_{x}(\sigma_{(Q, Y=R . Y ∧ Q . T>2)}(Q \times R)) __________.

GATE Computer Science (CS) 2019 Solved Papers

Question : 65 of 65

Marks: +1, -0

Consider the following relations P(X,Y,Z),Q(X,Y,T) and R(Y,V).

How many tuples will be returned by the following relational algebra query?

Π_{x}(σ_{(P, Y=R . Y ∧ R . V=v 2)}(P × R))-Π_{x}(σ_{(Q, Y=R . Y ∧ Q . T>2)}(Q × R))

__________.

Go to Question:

Prev Question