database modeling ch 6

JOB_CHG_HOUR

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

prime

An attribute that is part of a key is known as a(n) ____ attribute

the level of detail represented by the values stored in a table's row

Granularity refers to____

flexibility

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

normalization stages

1NF, 2NF, and 3NF are ___

repeating groups

A ____ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence

1NF

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

2NF

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

3NF

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

temporary

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

derived

From a system functionality point of view, ____ attribute values can be calculated when they are needed to write reports or invoices

partial dependencies

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

three

If you have three different transitive dependencies, ____ different determinant(s) exist.

compromises that include denormalization

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

Denormalization

____ yields better performance

cannot be further subdivided

an atomic attribute____