Exam 6: Normalization of Database Tables

A table is in BCNF if every determinant in the table is a foreign key.

Describe a dependency diagram and explain its purpose.

Unnormalized tables yield no simple strategies for creating virtual tables known as _____.

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

If database tables are treated as though they were files in a file system, the _____ never has a chance to demonstrate its superior data-handling capabilities.

Explain normalization and its different forms.

Granularity refers to _____.

Any attribute whose value determines other values within a row is known as a(n) _____.

_____ is a process to help reduce the likelihood of data anomalies.

Normalization works through a series of stages called normal forms.

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

From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.

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

An attribute that is part of a key is known as a(n) _____ attribute.

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.

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

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

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

The _____ is central to a discussion of normalization.