Exam 6: Normalization of Database Tables

Improving ____ leads to more flexible queries.

____ yields better performance.

With parrtial dependencies,data redundancies occur because every row entry requires duplication of data.

An attribute that cannot be further divided is said to display ____________________.

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

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

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

According to naming conventions described in Chapter 2,____ would be the best name for a column representing the charges per hour in a table named JOB.

The combination of normalization and ER modeling yields a useful ERD,whose entities may now be translated into appropriate relationship structures.

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

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

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

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

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

Normalization works through a series of stages called ___________________ forms.

A table is in BCNF if every determinant in the table is a candidate key.

To generate a surrogate key,Microsoft Access uses a(n)____ data type.

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.

Unnormalized database tables often lead to various data redundancy disasters in production databases.

____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.