Chapter 6 Normalization of Database Tables

From a structural point of view, 2NF is better than _____.

1NF

Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in ______.

2NF

Select one of the following table types which defines a table in 2NF that contains no transitive dependencies?

3NF

Which of the following tables contains no rows with two or more multivalued facts about an entity?

4NF

How would Microsoft Access generate a surrogate key?

AutoNumber

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

DKNF

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

Data warehouse

The combination of normalization and ER modeling yields a useful _______, whose entities can be translated into appropriate table structures.

ERD

In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.

True

In the context of partial dependencies, data redundancies occur because every row entry requires duplication of data.

True

Relational models view data as part of a table or collection of tables in which all key values must be identified.

True

If an attribute cannot be further subdivided, which of the following attributes would it display?

atomicity

Improving ________ leads to more flexible queries.

atomicity

If a table is in the third normal form (3NF) and is also considered to be in Boyce-Codd normal form, what functional dependencies are taken into account as determinants?

candidate keys

When using a system functionality point of view, which attribute values can be calculated when they are needed to write reports or invoices?

derived

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

When the related table uses a composite primary key, it becomes difficult to create which key?

foreign

A table is in 4NF if it is in 3NF, and _____.

it has no multivalued dependencies

An ERD is created through which of the following processes?

iterative

Mario wants to choose a dependency which is based on only a part of a composite primary key. Which dependency does Mario choose?

partial

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.

partial dependencies

According to a standard data-modeling checklist, the non-key entities in an entity-relationship (ER) data model must be fully dependent on _________.

the primary key

When using a data-modeling checklist to design a data structure, attribute names should:

use descriptive suffixes

Unnormalized tables yield no simple strategies for creating virtual tables known as _____.

views