Exam 6: Normalization of Database Tables

Normalization should be part of the design process.

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

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

What steps are involved in the conversion to third normal form?

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

In order to meet ___________________ requirements,you may have to denormalize some portion of the database.

All relational tables satisfy the ____________________ requirements.

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

Normalization represents a micro view of the entities within the ERD.

Converting a database format from 1NF to 2NF is a complex process.

If a table has multiple candidate keys and one of those candidate keys is a composite key,the table can have ____ based on this composite candidate key,even when the primary key chosen is a single attribute.

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

A table that displays data redundancies yields ____.

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

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

Granularity refers to ____.

Normalization produces a lower normal form.

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

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

It is possible for a table in 2NF to exhibit transitive dependency,where one or more nonprime attributes functionally determine other nonprime attributes.