Quiz 4

Normalization is a very important database design ingredient and the highest level is always the most desirable.

False

Normalization produces a lower normal form

False

The conflicts between design efficiency, information requirement, and processing speed are often resolved through ____

compromises that include denormalization

Attribute A ____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

determines

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

flexibility

1NF, 2NF, and 3NF are ____

normalization stages

The most likely data type for a surrogate key is ____

numeric

Dependencies based on only a part of a composite primary key are called ____ dependency

partial

Data redundancy produces ___

potential data integrity problems

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

repeating group

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

transitive dependency

____ is done to yield better performance

Denormalization

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 ____.

1NF

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

1NF

A table that is in 1NF and includes no partial dependencies is said to be in ____.

2NF

Before converting a table into 3NF, it is imperative the table already be in ____

2NF

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

3NF

For most business transactional databases, we should normalize relations into ____.

3NF

Some very specialized applications may require normalization beyond the ____.

4NF

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

True

A table is in 2NF if it is in 1NF and it includes no partial dependecies

True

All relational tables satisfy the 1NF requirements

True

Denormalization produces a lower normal form

True

In order to meet performance requirements, you may have to denormalize portions of the database design.

True

A table that displays data redundancies yields ____

anomalies