DATABASE DESIGN USING NORMALIZATION QUIZ

Eliminating modification anomalies is a(n) ________ of normalization.

neither an advantage nor disadvantage

disadvantage

advantage

either an advantage or disadvantage

TRUE ANSWER : ?
YOUR ANSWER : ?

When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

For a number of reasons, normalizations is not often an advantage for a(n) ________ database.

read-only

None of these

either a read-only or an updateable

updateable

TRUE ANSWER : ?
YOUR ANSWER : ?

One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:

first step.

fourth step.

third step.

second step.

TRUE ANSWER : ?
YOUR ANSWER : ?

Denormalized tables are in BCNF.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Proper normalization eliminates duplicated data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Normalization requires programmers to write more complex SQL.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:

first step.

third step.

second step.

fourth step.

TRUE ANSWER : ?
YOUR ANSWER : ?

The design guidelines and priorities for read-only databases are different because read-only databases are never updated.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑