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

GATE · 2019 · CS · Computer Science & IT

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 169 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…