Exam 4: Database Design Using Normalization

Database design varies depending on whether you're building an updatable database or a read-only database.

Null values are a problem because they are ambiguous.

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

During the second step of assessing table structure,you are trying to determine ________.

Normalization eliminates modification anomalies and data duplication.

When you are creating a database from existing data,you will have only minor problems with inconsistent values.

A classic example of unneeded normalization is when we are dealing with ________.

Anomalies caused by functional dependencies can be eliminated by putting tables into ________.

To determine the number and type of columns in a table,use the SQL construct COUNT(*).

To count the number of rows in a table,use the SQL construct COUNT(ROWS).

To limit the number of rows retrieved from a table,use the SQL TOP keyword.

A missing value is called a(n)________.

The SQL DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.

Denormalization is the process of joining previously normalized tables back together.

For a number of reasons,________ is not often an advantage for a read-only database.

When examining data values as a part of assessing table structure,you should try to determine two types of dependencies: functional dependencies and multivalued dependencies.

________ is the process of joining two or more tables and storing the result as a single table.

Writing SQL subqueries and joins against normalized tables is simple compared to the code that must be written to handle anomalies from multivalued dependencies.

What are null values,and why are they a problem?

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