Exam 6: Normalization of Database Tables

If you have three different transitive dependencies,____ different determinant(s)exist.

All relational tables satisfy the 1NF requirements.

BCNF can be violated only if the table contains more than one ____ key.

Because a partial dependency can exist only if a table's primary key is composed of several attributes,a table whose ____________________ key consists of only a single attribute is automatically in 2NF if it is in 1NF.

Normalization produces a lower normal form.

A ____ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.

An attribute that cannot be further divided is said to display ____________________.

Before converting a table into 3NF,it is imperative the table already be in ____.

Normalization works through a series of stages called normal forms.

A determinant is any attribute whose value determines other values within a column.

In order to meet ___________________ requirements,you may have to denormalize some portion of the database.

An atomic attribute ____.

In _________________________,no row may contain two or more multivalued facts about an entity.

A table is in 4NF if it is in 3NF and ____.

Explain the BCNF.How is it related to other normal forms?

Repeating groups must be eliminated by making sure that each row defines a single entity.

The most likely data type for a surrogate key is ____.

In a(n)____ diagram,the arrows above the attributes indicate all desirable dependencies.

The problem with transitive dependencies is that they still yield data ____________________.

It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.