ITSS 4300 Practice Quiz 4 - Normalization

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

1NF

what is the lowest minimum recommended normal form

1NF

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

2NF

a table that is in 2NF and contains no transitive dependencies is said to be in ______ .

3NF

some very specialized applications may require normalization beyond the ______ .

4NF

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.

True

normalization is a process that is used for changing attributes to entities.

false

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

an attribute that is part of a key is known as a(n) ______ attribute.

prime