Chapter 6 Quiz

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

flexibility

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

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

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

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