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

PYQ GATE 2019

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=V2))(P×R))–Πx(σ(Q.Y=R.Y∧Q.T>2))(Q×R))\Pi_x (\sigma_{(P.Y=R.Y \wedge R.V=V2))} (P \times R)) – \Pi_x (\sigma_{(Q.Y = R.Y \wedge Q.T>2))} (Q \times R))

Answer: ___________.

Attempted by 204 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…