DATABASE DESIGN USING NORMALIZATION QUIZ

Normalization requires programmers to write more complex SQL.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Proper normalization eliminates duplicated data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When building a database from an existing set of tables, we still need to consider normalization principles.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

read-only

updateable

either a read-only or an updateable

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 : ?

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

either an advantage or disadvantage

disadvantage

neither an advantage nor disadvantage

advantage

TRUE ANSWER : ?
YOUR ANSWER : ?

Each answer below shows example data from a table. Which answer is an example of the missing values problem?

One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

Three rows have the values Brown, NULL, and Blue in the same column.

TRUE ANSWER : ?
YOUR ANSWER : ?

We use the SQL construct COUNT(*) to count the number of rows in a table.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑