TERM 1
Select
DEFINITION 1
-Take rows (using criteria) from one table to create a new
table General form: Select Test From Table Example: Select
marathon_place=1 From Olympic_Marathon_Medal_Winners
Test can be any sort of criteria , , =, text comparison
TERM 2
Project
DEFINITION 2
-Take columns from a table to create new table General
form: Project Field_list From Table Example: Project
FirstName, Birthdate From Person
TERM 3
Union
DEFINITION 3
-Combine 2 tables Can only be performed if the 2 tables have
the same set of attributes General Form: Table1 + Table2
Example: If we had 2 tables Men and Women People = Men
+ Women
TERM 4
Difference
DEFINITION 4
-Remove from one table the rows also listed in a second table
General Form: Table1 Table2 Remove from Table1 any rows
that are also in Table2 Women = People - Men
TERM 5
Product
DEFINITION 5
-Multiply two tables Has all the fields from both tables
Appending/concatenating each row of second table to each
row of first table General form: Table1 x Table2 Example:
Courses x Faculty Produces all possible pairings, some may
not belong together
