Question 10824 – APPSC-2016-DL-CS
November 26, 2023Logical-Reasoning
November 26, 2023Question 7800 – Database-Management-System
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))
Correct Answer: B
Question 6 Explanation:
σ(P.Y = R.Y ∧ R.V = V2)(P × R)

∏x(σ(P.Y = R.Y ∧ R.V = V2)(P × R))

σ(Q.Y = R.Y ∧ Q.T>2)(Q × R)

∏x(σ(Q.Y = R.Y ∧ Q.T>2)(Q × R))

∏x(σ(P.Y = R.Y ∧ R.V = V2)(P × R)) – ∏x(σ(Q.Y = R.Y ∧ Q.T>2)(Q × R))

∏x(σ(P.Y = R.Y ∧ R.V = V2)(P × R))
σ(Q.Y = R.Y ∧ Q.T>2)(Q × R)
∏x(σ(Q.Y = R.Y ∧ Q.T>2)(Q × R))
∏x(σ(P.Y = R.Y ∧ R.V = V2)(P × R)) – ∏x(σ(Q.Y = R.Y ∧ Q.T>2)(Q × R))
0
1
2
3
Subscribe
Login
0 Comments