DATABASE DESIGN USING NORMALIZATION QUIZ

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

second step.

third step.

first step.

fourth step.

TRUE ANSWER : ?
YOUR ANSWER : ?

The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Normalization requires programmers to write more complex SQL.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

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

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

second step.

first step.

fourth step.

third step.

TRUE ANSWER : ?
YOUR ANSWER : ?

Denormalized tables are in BCNF.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Proper normalization eliminates duplicated data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Multivalued dependencies should ________ be eliminated.

commonly

always

seldom

never

TRUE ANSWER : ?
YOUR ANSWER : ?

In all cases, normalization into BCNF is desirable.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑