Chapter 5

The conversion of an unnormalized table to first normal form requires the removal of ____.​

An alternate key is a ____.​

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key, the others are referred to as ____.​

Potential problems in the design of a relational database are known as ____.​

If B (an attribute) is functionally dependent on A, we can also say that ____.​

A table is in first normal form if it does not contain ____.​

​A table is in fourth normal form when it is in third normal form and there are no ____.

The definition for ____ also defines a candidate key.​

From all the ____ keys, one is chosen to be the primary key.​

The fact that column B is functionally dependent on column A can be written as ____.​

____ normal form has an additional condition that the only determinants the table contains are candidate keys.​

Which of the following contains a repeating group?​ ​Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) ​Orders (OrderNum, ItemNum, NumOrdered ) ​Orders (OrderNum, OrderDate) ​Orders (OrderNum, OrderDate, ItemNum, NumOrdered )

Second normal form can be defined as a table that is in first normal form but that contains no ____.​

The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.​

​A table that contains a repeating group is called a(n) ____.

A table that is in first normal form is better than one that is in second normal form.​

By splitting relations to achieve third normal form tables, you create the need to express interrelation constraints.​

If the primary key of a table contains only a single column, the table is automatically in first normal form.​

Converting to third normal form always avoids the problems related to dependencies.​

Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as possible.​

A table that is in first normal form may contain problems that will require you to restructure it.​

In general, when converting a non-first normal form table to first normal form, the primary key will usually include the original primary key concatenated with the key to the repeating group.​

The primary key in a table will be a determinant.​

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

In a dependency diagram, the arrows below the boxes indicate the normal dependencies.​

A column is a nonkey column if it is ____.​

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.​

To convert a table to fourth normal form, split the third normal form table into separate tables, each containing the column that ____ the others.​

Another name for a nonkey column is a ____.​

Partial dependencies are dependencies on only a portion of the ____.​

Tables that are in second normal form do not contain problems.​

The most recent definition of third normal form is referred to as the Boyce-Codd normal form.​

Functional dependencies can be determined by looking at sample data.​