Relational Algebra

Selection

Selection

Finds all specified rows

Projection

Projection

Finds all specified columns

Union

Union

Finds all specified values, in two type compatible specified columns

Intersection

Intersection

Finds all specified values with equal, type compatible values in another specified column

Set Difference

Set Difference

Finds all values specified, unless they have a matching value in another specified column

Natural Join

Natural Join

Finds all values that share values in specified columns in two different entity tables

Theta Join

Theta Join

Compares first entity to second entity based on the comparison expression specified in place of theta

Outer Join

Left Outer Join

Finds a common column between both tables. Takes the values of the left tables columns and combines them with values from the right table based on matches. If no matches are found use null for right table values. (Preserve)

Right Outer Join

Same as left outer join, but combining and comparing right side to left side.

Cartesian Product

Cartesian Product

Combines each row on left table with every row on right table

Divide By

Divide By

Find specified values with at least the specified values on the other side

Rename

Rename

Renames a specified values by placing the new name in front of it in the command. Can rename multiple values by separating by commas