Chapter 6 Quiz

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 2NF 3NF 4NF

1NF

A table that is in 2NF and contains no transitive dependencies is said to be in _____. 1NF 2NF 3NF 4NF

3NF

For most business transactional databases, we should normalize relations into _____. 1NF 2NF 3NF 6NF

3NF

A table where every determinant is a candidate key is said to be in _____. BCNF 2NF 1NF 4NF

BCNF

An atomic attribute _____. cannot exist in a relational table cannot be further subdivided displays multiplicity is always chosen to be a foreign key

cannot be further subdivided

In a real-world environment, we must strike a balance between design integrity and _____. robustness flexibility uniqueness ease of use

flexibility

Dependencies based on only a part of a composite primary key are known as _____ dependencies. primary partial incomplete composite

partial

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence. partial dependency transitive dependency repeating group primary key

repeating group

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. transitive 3NF component temporary

temporary

Granularity refers to _____. the size of a table the level of detail represented by the values in a table's row the number of attributes represented in a table the number of rows in a table

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