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

The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included.

A relational database is a collection of relations.

____________________ is a theoretical way of manipulating a relational database.

An unnormalized relation is a table that has more than one row.

Rows are also called ____.

A ____ query creates a new table using the query results.

Provide a definition for the term relation.

The concept of grouping means that statistics will be calculated for individual records.

With ____________________,users ask their questions by entering column names and other criteria using an on-screen grid,and data that appears on the screen in tabular form.

If each sales rep is related to the many customers he or she represents,and each customer is related to the one sales rep who represents it,then there is a(n) ____________________ relationship between sales reps and customers.