Exam 9: Normalizing Database Designs

In order to meet performance requirements, you may have to denormalize portions of the database design.

A relational table must not contain a(n) ____.

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.

____ yields better performance.

Denormalization produces a lower normal form.

Data redundancies occur from ____________________ of data on every row entry.

Any attribute that is at least part of a key is known as a(n) ____________________.

From a structural point of view, 2NF is better than ____.

Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?

Attributes should clearly define participation, connectivity, and document cardinality.

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

The ____________________ provides the big picture, or macro view, of an organization's data requirements and operations.

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 attribute that is part of a key is known as a(n) ____ attribute.

Granularity refers to ____.

What steps are involved in the conversion to third normal form?

____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

Describe a dependency diagram and explain its purpose.

For most business transactional databases, we should normalize relations into ____.

If database tables are treated as though they were files in a file system, the ____________________ never has a chance to demonstrate its superior data-handling capabilities.