Exam 6: Normalization of Database Tables

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.

Improving ____ leads to more flexible queries.

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

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

A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

Any attribute that is at least part of a key is known as a(n)____________________.

A relational table must not contain ____________________ groups.

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

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

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

A good relational DBMS excels at managing denormalized relations.

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

A table where every determinant is a candidate key is said to be in ____.

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

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 is stored in the table as rows.

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

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

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

Relational models view the data as part of a table or collection of tables in which all key values must be identified.

The ____________________ provides the big picture,or macro view,of an organization's data requirements and operations.