Exam 9: Normalizing Database Designs

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

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

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

A(n) ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.

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

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.

The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.

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

Some very specialized applications may require normalization beyond the ____.

Normalization produces a lower normal form.

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

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

Data redundancy produces ____.

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of ____________________ keys.

Dependencies based on only a part of a composite primary key are called ____ dependencies.

Dependencies can be identified with the help of a dependency ____________________.

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

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

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