DATABASE DESIGN USING NORMALIZATION QUIZ

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Denormalized tables are in BCNF.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

first step.

fourth step.

third step.

second step.

TRUE ANSWER : ?
YOUR ANSWER : ?

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

The missing values problem

The general-purpose remarks column problem

The multivalue, multicolumn problem

The inconsistent values problem

TRUE ANSWER : ?
YOUR ANSWER : ?

When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:

fourth step.

second step.

first step.

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

Most of the time, modification anomalies are serious enough that tables should be normalized into:

1NF.

3NF.

2NF.

BCNF.

TRUE ANSWER : ?
YOUR ANSWER : ?

Creating a read-only database is a task that is ________ assigned to beginning database professionals.

commonly

never

always

seldom

TRUE ANSWER : ?
YOUR ANSWER : ?

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

second step.

third step.

fourth step.

first step.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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.

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.

TRUE ANSWER : ?
YOUR ANSWER : ?