Exam 2: The Relational Model 1: Introduction, QBE, and Relational Algebra

A(n) ____________________ database is a collection of tables.

What type of query creates a new table using the query results?

What uniquely identifies a row in a table?

To list the records in a query's results in a particular order, you need to ____________________ the records.

A ____________________ query in Access allows you to enter criterion when you run the query, as opposed to placing it in the design grid.

If you are sorting records by more than one field, which field is the more important field?

In Access, a parameter query allows you to enter criterion when you run the query.

Discuss the difference between the major sort key and the minor sort key.

The relationships between tables are implemented through common ____________________.

Which operation is performed by the SUBTRACT command in relational algebra?