Exam 5: Database Design 1: Normalization

Tables that are in second normal form can still contain redundancy problems.

A column is a nonkey column if it is not a part of the ____________________.

What is the difference between a third normal form and fourth normal form table?

When converting a non-first normal form table to first normal form, the foreign key will usually include the original foreign key concatenated with the key to the repeating group.

What is the difference between a table in first normal form and one in second normal form?

Discuss what normal forms are and list the most common normal forms.

Any column or collection of columns that determines another column is called a(n) ___________________.

Which of the following contains a repeating group where the primary key is OrderNum?

A table is in fourth normal form (4NF) when it is in third normal form and there are no multivalued dependencies.

What is each key that meets the criteria for a primary key called?

Third normal form is sometimes referred to as the Boyce-Codd normal form.

If B is functionally dependent on A, what can you also say?

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

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

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

When the ____________________ of a table is a single column, the table is automatically in second normal form.

Which of the following can be defined as 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?

Describe the procedure for converting a table to the third normal form.

Which term's definition also defines a candidate key?

Describe the normalization process.