Exam 2: Database Design Fundamentals

If B is functionally dependent on A, you also can say that A functionally ____________________ B.

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

In a relational database, column B is ____________________ on another column A, if at any point in time a value for A determines a single value for B.

The four categories of update anomalies are additions, deletions, inconsistent data, and ____________________.

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you can determine the pay rate.

A primary key always comprises a single column.

A relationship is an association between ____________________.

A field is another term for a(n) ____.

An unnormalized relation is a relation that may contain repeating groups.

A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support.

A secondary key is the unique identifier for a table.

A tabular database is a collection of tables.

In a relational database, relationships are implemented by having common columns in two or more tables.

When you write a column in the format CUSTOMER.REP_NUM, you say that you ____________________ the column name.

Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?

Because there is a one-to-many relationship between sales reps and customers in the Premiere Products database, one sales rep can be associated with zero, one, or more customers.

In an entity-relationship (E-R) diagram, one-to-many relationships between entitities are drawn as ____.

When you combine a column name with a table name, you are said to ____________________ the column name.

Which of the following symbols is used to qualify column names?

____ is the formal term for combining two or more columns to form a primary key.