Data Systems Ch. 6

____ refers to the level of detail represented by the values stored in a table's row.

Granularity

A ________ is any attribute whose value determines other values within a row.

determinant

A table is in fourth normal form (4NF) if ________.

it is in 3NF and has no independent multivalued dependencies

Identification of the ________ will let you know where you are in the normalization process.

normal form

Unnormalized tables yield no simple strategies for creating virtual tables, which are also known as ________.

views

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

2NF

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

3NF

For most business database design purposes, ________ is as high as you need to go in the normalization process.

3NF

Most designers consider Boyce-Codd normal form (BCNF) as a special case of ________.

3NF

Tables in ________ will perform suitably in business transactional databases.

3NF

Which of the following would be the best name for a column representing the charges per hour in a table named JOB?

JOB_CHG_HOUR

In a normalized database, what is represented by each table?

a single subject

A table that displays data redundancies yields ________.

anomalies

The normalization process involves assigning ________ to tables based on the concept of determination.

attributes

When a table contains only one ________ key, the 3NF and the BCNF are equivalent.

candidate

A ________ key makes it more difficult to write search routines.

composite primary

The conflicts between design efficiency, information requirements, and performance are often resolved through ________.

compromises that may include denormalization

Lower normalization forms occur (and are even required) in specialized databases known as ________.

data warehouses

In BCNF, every ________ in a table is a candidate key.

determinant

Dependencies can be depicted with the help of a dependency ________.

diagram

When designing a database you should ________.

make sure entities are in normal form before table structures are created.

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

partial

Given the following table definition, how many tables would be produced by the conversion to 2NF? 1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, ASSIGN_HOURS) with PROJ_NUM & EMP_NUM AS PRIMARY KEY IDENTIFIERS

three see pg. 190

A 2NF table can exhibit ________ dependency.

transitive