Database Normalization Worksheet (Transcribed)

Normalization works through a series of stages called normal forms.

• True

• False

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

• True

• False

In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.

• True

• False

Denormalization produces a lower normal form.

• True

• False

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

• True

• False

Relational models view data as part of a table or collection of tables in which all key values must be identified.

• True

• False

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

• True

• False

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

• True

• False

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

• True

• False

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

• True

• False