database M6

it has no multivalued dependencies

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

True

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies. T or F

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

3NF

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

4NF

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

transitive dependency

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.

cannot be further subdivided

An atomic attribute _____.

Prime

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

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 are stored in the table as rows.

Determines

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.

Candidate

BCNF can be violated only if the table contains more than one _____ key.

2NF

Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.

True

Denormalization produces a lower normal form. T or F

False

Dependencies that are based on only a part of a composite primary key are called transitive dependencies. T or F

1NF

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

Derived

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

derived

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

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

Granularity refers to _____.

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.

Dependency

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

True

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

Three

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

True

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. T or F

AutoNumber

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

the 3NF and the BCNF

When a table contains only one candidate key, _____ are considered to be equivalent.

Data warehouse

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

True

the objective of normalization is to ensure that each table conforms to the concept of well formed relations. T or F