Database Management and WarehousingRelational AlgebramediumMCQ2 marks
Consider the given relations \(X\), \(Y\) and \(Z\). The relation \(X\) has three columns P, Q and R. The relation \(Y\) has three columns P, Q and S. The relation \(Z\) has two columns P and T.
Relation X:
P
Q
R
P1
Q1
R1
P2
Q2
R2
P3
Q3
R2
Relation Y:
P
Q
S
P1
Q1
2
P1
Q2
5
P2
Q1
6
P3
Q3
1
Relation Z:
P
T
P1
T1
P3
T2
P4
T3
P4
NULL
Consider the relational algebra expression
\[ \Pi_{P,R,S}\Big[\big(\sigma_{(Q=Q3 \vee R=R2)}[X \Join Y]\big) \Join \big(\sigma_{(S>1)}[Y \Join Z]\big)\Big] \]
where \(\Join\) denotes natural join operation.
Which of the following options is the correct output for the given expression?