Exam 6: Normalization of Database Tables

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

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

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute.

A table is in 4NF if it is in 3NF, and _____.

Any attribute that is at least part of a key is known as a(n) _____.

Explain the Boyce-Codd normal form (BCNF). How is it related to other normal forms?

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

A relational table must not contain a(n) _____.

_____ refers to the level of detail represented by the values stored in a table's row.

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

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.

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

In a real-world environment, we must strike a balance between design integrity and _____.

Because a partial dependency can exist only when a table's primary key is composed of several attributes, a table whose _____ key consists of only a single attribute is automatically in 2NF once it is in 1NF.

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

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

An example of denormalization is using a _____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows.

What steps are involved in the conversion to third normal form?

In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.