DATABASE DESIGN USING NORMALIZATION QUIZ

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

False

True

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

Denormalized tables are in BCNF.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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:

third step.

first step.

fourth step.

second step.

TRUE ANSWER : ?
YOUR ANSWER : ?

Normalization ________ data duplication.

maximizes

increases

eliminates

reduces

TRUE ANSWER : ?
YOUR ANSWER : ?

One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

second step.

first step.

third step.

fourth step.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑