The Relational Model: Manipulation - Relational Algebra

• Six basic operators
• Set union
• Set difference
• Cartesian product (cross join)
• Selection
• like SQL's WHERE (color == "yellow")
• Projection - subset of attributes from a relation
• part_number and part_name from Part
• Rename
• part_name AS name
• Everything else is defined in terms of those operators