Chapter 7 DATABASE MIDTERM (week 10 quiz)

The most likely data type for a surrogate key is ____. Character Date Logical Numeric

Numeric

From a system functionality point of view, ____ attribute values can be calculated when they are needed to write reports or invoices. derived atomic granular historical

derived

Normalization represents a micro view of the ____ within the ERD. entities attributes relationships forms

entities

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

3NF

Most designers consider the BCNF as a special case of the ____. 1NF 2NF 3NF 4NF

3NF

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

BCNF

Improving ____ leads to more flexible queries. atomicity normalization denormalization derived attributes

atomicity

The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____. conversion from 1NF to 2NF conversion from 2NF to 3NF compromises that include denormalization conversion from 3NF to 4NF

compromises that include denormalization

A table is in 4NF if it is in 3NF and ____. all attributes must be dependent on the primary key, and must be dependent on each other all attributes are unrelated has no multivalued dependencies no column contains the same values

has no multivalued dependencies