IT 214 Chapter 6

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

Repeating groups must be eliminated by making sure that each column defines a single entity.

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

A dependency based on only a part of a composite primary key is called a(n) _________

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

With parrtial dependencies, data redundancies occur because every row entry requires duplication of data

Any attribute whose value determines other values within a row is called a(n) ________

The problem with transitive dependencies is that they still yield data _______

Normalization should be part of the design process.

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 order to meet ___________________ requirements, you may have to denormalize some portion of the database.

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

A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____

Normalization works through a series of stages called normal forms.

Denormalization produces a lower normal form.

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

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

When designing a database, you should ____.

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

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

Of the following normal forms, ____, is mostly of theoretical interest.

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

Atomic attributes are attributes that can be further divided.

Improving ____ leads to more flexible queries.

Normalization is a process that is used for changing attributes to entities