Queries: Create Tables from Tables
Concept: The operations on databases, Select, Project, Union, Difference Product create tables from tables called Queries
Implementation: Database systems come with a “query language” … SQL is the most common
Syntax: Define the query in standard form
Select <fields of desired table>
From <list of tables>
Where <criteria for creating/combining table>
Access has two query languages, SQL and QBE,
Query By Example … SW translates QBE into SQL