Operations on Tables

Surgical Tables — Goldberg Med

• A database is a collection of database tables
• Main use of database is to look up information
– Users specify what they want to know and the database
software finds it
• We can perform operations on tables to produce new
tables (that are not explicitly part of the schema)
• The questions we ask of a database are answered with
a whole table
• Five fundamental operations that can be performed
on tables: Select, Project, Union, Difference, Product.