Consider the given relations π, π and π. The relation π has three columnsβ¦
GATE Β· 2026 Β· DA Β· Data Science & AI
Consider the given relations π, π and π. The relation π has three columns π, π and π . The relation π has three columns π, π and π. The relation π has two columns π and π.
X: P | Q | R |
|---|---|---|
P1 | Q1 | R1 |
P2 | Q2 | R2 |
P3 | Q3 | R2 |
Y: P | Q | S |
|---|---|---|
P1 | Q1 | 2 |
P1 | Q2 | 5 |
P2 | Q1 | 6 |
P3 | Q3 | 1 |
Z: P | T |
|---|---|
P1 | T1 |
P3 | T2 |
P4 | T3 |
P4 | NULL |
Consider the relational algebra expression
βππ π[(π(π = π3 β¨ π = π 2)[π β¨ π])β¨(π(π > 1)[π β¨ π])]
where β¨ denotes natural join operation.
Which of the following options is the correct output for the given expression?
- A.
Two rows (P1, R1, 2) and (P1, R1, 5)
- B.
Three rows (P1, R1, 2), (P1, R1, 5) and (P2, R2, 6)
- C.
One row (P1, R1, 2)
- D.
Zero rows
Attempted by 12 students.
Sign up free to check your answer
Sign up freeLoading lessonβ¦