Exam 6: Normalization of Database Tables

Explain how database designers design and normalize databases.

Of the following normal forms, is mostly of theoretical interest.

A table where every determinant is a candidate key is said to be in .

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have based on this composite candidate key even when the primary key chosen is a single attribute.

The conflicts between design efficiency, information requirements, and performance are often resolved through_____.

Normalization represents a micro view of the entities within the ERD.

It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.

Normalization works through a series of stages called normal forms. For most purposes in business database design, stages are as high as you need to go in the normalization process.

A table is in BCNF if every determinant in the table is a candidate key.

Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.