Recall that there are 5 basic relational algebra operators: $\pi$, $\sigma$, $\times$, $-$, $\cup$
Assume T1, T2 and T3 are relations:
$\bullet$ T1 has schema {x}
$\bullet$ T2 has schema {x, y}
$\bullet$ T3 has schema {x, y, z}
Rewrite the following relational algebra queries using only the 5 basic operators (plus
the renaming operator if desired). This is the only part of the assignment where we
don't want you to use the complex operators such as natural join.
1.
$T2 \bowtie T3$
2.
$\pi_x (T2) \cap T1$
3.
$\pi_z (T3 \bowtie_{T3.y == T2.y} T2)$
4.
T2/T1
