Exam 6: Normalization of Database Tables

Denormalization produces a lower normal form.

To generate a surrogate key, Microsoft Access uses a(n) _____ data type.

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.

A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.

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

Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

An ERD is created through a(n) _____ process.

What characteristics do tables that conform to the concept of well-informed relations have?

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.

An atomic attribute _____.

Some very specialized applications may require normalization beyond the _____.

In order to meet _____ requirements, you may have to denormalize some portions of a database design.

Improving _____ leads to more flexible queries.

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

An attribute that cannot be further subdivided is said to display _____.