Ch. 6 Quiz

In a real-world environment, we must strike a balance between design integrity and _____. - ease of use - flexibility - uniqueness - robustness

flexibility

A table is in 4NF if it is in 3NF, and _____. - it has no multivalued dependencies - all attributes must be dependent on the primary key and must be dependent on each other - all attributes are unrelated - no column contains the same values

it has no multivalued dependencies

In a ______ situation, one key determines multiple values of two other attributes and those attributes are independent of each other. - multivalued dependency - partial dependency - functional dependency - transitive dependency

multivalued dependency

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. - Boyce-Codd normal forms - time-variances - redundancies - partial dependencies

partial dependencies

A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key. - repeating group - partial dependency - atomic attribute - transitive dependency

transitive dependency

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 - 3NF - 4NF - INF

1NF

From a structural point of view, 2NF is better than _____. - 3NF - INF - BCNF - 4NF

1NF

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment. - INF - 2NF - 3NF - 4NF

2NF

A table that is in 2NF and contains no transitive dependencies is said to be in _____. - 2NF - INF - 4NF - 3NF

3NF

A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____. - INF - 2NF - 4NF - 3NF

4NF

To generate a surrogate key, Microsoft Access uses a(n) ______ data type. - AutoNumber - identity - sequence - character

AutoNumber

Of the following normal forms, _____ is mostly of theoretical interest. - BCNF - DKNF - INF - 3NF

DKNF

BCNF can be violated only if the table contains more than one _____ key. • primary • foreign • secondary • candidate

candidate

An atomic attribute ______. • displays multiplicity • cannot be further subdivided • cannot exist in a relational table • is always chosen to be a foreign key

cannot be further subdivided

In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies. - functionality - ER - dependency - Chen

dependency

From a system functionality point of view, ______ attribute values can be calculated when they are needed to write reports or invoices. - derived - historical - granular - atomic

derived

Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B. - controls - owns - derives from - determines

determines

The most likely data type for a surrogate key is _____. • numeric • logical • character • date

numeric

Dependencies based on only a part of a composite primary key are known as ______ dependencies. - incomplete - partial - primary - composite

partial

An attribute that is part of a key is known as a(n) ______ attribute. - entity - nonprime - prime - important

prime

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence. - repeating group - partial dependency - transitive dependency - primary key

repeating group

A relational table must not contain a(n) _____. - entity - attribute - relationship - repeating group

repeating group

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 are stored in the table as rows. - 3NF - temporary - component - transitive

temporary

When a table contains only one candidate key, _____ are considered to be equivalent. • the INF and the 2NF • the 4NF and the 3NF • the BCNF and the DKNF • the 3NF and the BCNF

the 3NF and the BCNF

Normalization works through a series of stages called normal forms. For most purposes in business database design, ______ stages are as high as you need to go in the normalization process. - four - two - five - three

three