Quiz Chapter 6

All relational tables satisfy the _______ requirements.

1NF

In the ______, no row may contain two or more multivalued facts about an entity.

4NF

When a non-key attribute is the determinant of a key attribute, the table is in 3NF but not in ______.

BCNF

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

Granularity

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

Normalization

The problem with transitive dependencies is that they still yield data ______.

anomalies

An attribute that cannot be further subdivided is said to display ______.

atomicity

The ______ is central to a discussion of normalization.

concept of keys

Any attribute whose value determines other values within a row is known as a ______.

determinant

Dependencies can be identified with the help of a dependency ______.

diagram

Data redundancies occur from ______ of data on every row entry.

duplication

According to the data-modeling checklist, ______ should be nouns that are familiar to business, should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity.

entity names

It becomes difficult to create a suitable ______ key when the related table uses a composite primary key.

foreign

An ERD is created through a (n) ______ process.

iterative

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

normalization

A dependency based on only a part of a composite primary key is called a ______.

partial dependency

Because a partial dependency can exist only when a table's primary key is composed of several attributes, a table whose ______ key consists of only a single attribute is automatically in 2NF once it is in 1NF.

primary

Any attribute that is at least part of a key is known as a ______.

prime attribute

The price paid for increased performance through Denormalization is a larger amount of ______.

redundancy

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of ______ keys.

surrogate