Exam 6: Normalization of Database Tables

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

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.

The price paid for increased performance through denormalization is a larger amount of ___________________.

Some very specialized applications may require normalization beyond the ____.

Atomic attributes are attributes that can be further divided.

Any attribute whose value determines other values within a row is called a(n)____________________.

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

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

The ____________________ provides the big picture,or macro view,of an organization's data requirements and operations.

A diagram that depicts all dependencies found within a given table structure is known as a(n)____________________.

BCNF can be violated only if the table contains more than one ____ key.

It becomes difficult to create a suitable ____________________ key when the related table uses a composite primary key.

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 is stored in the table as rows.

A good relational DBMS excels at managing denormalized relations.

1NF,2NF,and 3NF are ____.

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

A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y,and X is the primary key.

An atomic attribute ____.

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

The problem with transitive dependencies is that they still yield data ____________________.