Exam 6: Normalization of Database Tables

Granularity refers to ____.

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.

A table that is in 2NF and contains no transitive dependencies is said to be in ____.

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

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

Data redundancies occur from ____________________ of data on every row entry.

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

Explain normalization and its different forms.

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.

When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not _________________________.

Normalization purity is easy to sustain in the modern database environment.

Normalization should be part of the design process.

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.

Most designers consider the BCNF as a special case of the ____.

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

Of the following normal forms,____ is mostly of theoretical interest.

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

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

When designing a database,you should ____.

Describe a dependency diagram and explain its purpose.