Exam 5: Database Design 1: Normalization

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

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

By splitting relations to achieve third normal form tables,you create the need to express a(n) ____________________ constraint,a condition that involves two or more relations.

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 other choices are referred to as ____.

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

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

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

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 conversion of an unnormalized table to first normal form requires the removal of ____.

____________________ dependencies are dependencies on only a portion of the primary key.

What are the four categories of update anomalies and why could these problems occur when a relation is in first normal form but not in second normal form?

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

The primary key in a table is a determinant but candidate keys are not determinants.

Tables that are in second normal form do not update anomalies.

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

To correct update anomalies in a database,tables must be converted into various types of normal forms.

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

Functional dependencies can be determined by looking at sample data.

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

Another name for a nonkey column is a ____.