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

The attributes of an entity become the rows or records in a table.

Based on the statement below,which of the following is the primary key? Part (PartNum,Description,OnHand,Class,Warehouse,Price)

When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.

Which operation will allow you to extract data from more than one table?

A query that changes data is a(n) ____ query.

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

In a relation,the order of rows is important.

The ____ command within relational algebra takes a vertical subset of a table.

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.

List at least six of the aggregate functions available in Access. Explain how to use any of these functions in a query.

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

In relational algebra,the ____________________ of two tables is table containing all rows that are common in both table A and table B.

In Access,you can add all fields from a table to the design grid by double-clicking the ____________________ in the table's field list.

In a relation,the order of the columns is immaterial.

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data.

A relation is a(n) ____.

Based on the Customer table below,which command lists all information from the table concerning customer 524? CustomerNum CustomerName Street City State Zip 462 Bargains Galore 3829 Central Grove FL 33321 524 Kline's 838 Ridgeland Filmore FL 33336

In an OR criterion,the overall criterion is true if either of the individual criteria is true.

Explain what relational algebra is and how it is used.

The compound criteria (conditions) are created by using ____.