Exam 9: Normalizing Database Designs

A table is in 2NF if it is in 1NF and it includes no partial dependencies.

Repeating groups must be eliminated by making sure that each row defines a single entity.

All relational tables satisfy the 1NF requirements.

A relational table must not contain ____________________ groups.

A dependency based on only a part of a composite primary key is called a(n) ____________________.

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

When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not ____________________.

Normalization is a process that is used for changing attributes to entities.

In ____________________, no row may contain two or more multivalued facts about an entity.

Normalization works through a series of stages called normal forms.

Unnormalized database tables often lead to various data redundancy disasters in production databases.

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.

Because 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.

A table that displays data redundancies yields ____.

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

Describe a dependency diagram and explain its purpose.

Normalization should be part of the design process.

A good relational DBMS excels at managing denormalized relations.

According to naming conventions described in Chapter 2, ____ would be the best name for a column representing the charges per hour in a table named JOB.

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