Last updated 4 years ago
Queries in SQL have the following query structure:
select A1, A2, ..., An from r1, r2, ..., rm where P
This is equivalent to the following relational algebra expression, and will output a relation.
ΠA1,A2,...,An(σP(r1×r2×...× rm))\Pi _{A_1, A_2, ..., A_n} (\sigma _P (r_1 \times r_2 \times ...\times \, r_m))ΠA1,A2,...,An(σP(r1×r2×...×rm))