5
Relational Algebra
•
Five operators:
–
Union:
È
–
Difference: -
–
Selection:
s
–
Projection:
P
–
Cartesian Product:
´
•
Derived or auxiliary operators:
–
Intersection, complement
–
Joins (natural,equi-join, theta join, semi-join)
–
Renaming:
r