Exam 6: Normalization of Database Tables

A relational table must not contain a(n).

The conflicts between design efficiency,information requirements,and performance are often resolved through_____.

Explain normalization and its different forms.

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

All relational tables satisfy the 1NF requirements.

A determinant is any attribute whose value determines other values within a column.

A table where all attributes are dependent on the primary key but are independent of each other,and no row contains two or more multivalued facts about an entity is said to be in .

An attribute that cannot be further subdivided is said to display .

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.

When a table contains only one candidate key,are considered to be equivalent.

An atomic attribute .

A table that has all key attributes defined,has no repeating groups,and all its attributes are dependent on the primary key is said to be in .