Exam 5: Database Design 1: Normalization

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

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

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.

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

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

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

The ____________________ process enables you to identify the existence of potential problems in the design of a database.

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

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

A B signifies that B is ____________________ on A.