Exam 5: Database Design 1: Normalization

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

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.​

A(n)____________________ uses arrows to indicate all the functional dependencies present in the table.​

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

A(n)____________________ is a condition that involves two or more relations.​

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

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

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

Discuss how candidate keys,primary key,and alternate keys are related.​

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

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

Another name for a nonkey column 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 ____.​

Second normal form represents an improvement over ____________________ normal form.​

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

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

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

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

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

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