Exam 6: Normalization of Database Tables

The combination of _____ and ER modeling yields a useful ERD, whose entities may now be translated into appropriate table structures.

A table that is in 2NF and contains no transitive dependencies is said to be in _____.

Normalization purity is often easy to sustain in the modern database environment.

When a table contains only one candidate key, _____ are considered to be equivalent.

All relational tables satisfy the _____ requirements.

From a structural point of view, 3NF is better than _____.

The price paid for increased performance through denormalization is a larger amount of _____.

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.

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

The combination of normalization and ER modeling yields a useful ERD, whose entities can be translated into appropriate table structures.

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

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

According to the data-modeling checklist, _____ should be nouns that are familiar to business, should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity.

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.

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

Data stored at their highest level of granularity are said to be atomic data.

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.

All relational tables satisfy the 1NF requirements.

A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

When designing a new database structure based on the business requirements of the end users, the database designer will construct a data model using a technique such as _____.