Chapter 6

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

• True

• False

Denormalization produces a lower normal form.

• True

• False

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

• True

• False

For most business transactional databases, we should normalize relations into ____.

• 1NF

• 2NF

• 3NF

• 4NF

Normalization is a very important database design ingredient and the highest level is always the most desirable.

• True

• False

In order to meet performance requirements, you may have to denormalize portions of the database design.

• True

• False

All relational tables satisfy the 1NF requirements.

• True

• False

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.

• True

• False

With partial dependencies, data redundancies occur because every row entry requires duplication of data.

• True

• False

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

• True

• False