Exam 4: Database Design Using Normalization

When examining data values as a part of assessing table structure,you should try to determine three types of keys: the primary key,any candidate keys and any foreign keys.

The first step in assessing table structure includes ________.

Reviewing the work done on a table that was created using existing data from multiple sources,you are likely to find that some data values that were provided were never entered into the table.This is an example of ________.

Explain denormalization,and why it may be appropriate to denormalize a set of tables.

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

Unlike the anomalies from functional dependencies,the anomalies from ________ are so serious that they should always be eliminated.

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

The SQL INSERT statement can be used to populate normalized tables.

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

A missing value is called a(n)________.

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

When a table is created using existing data from multiple sources,you are likely to find that the different sources code data in slightly different ways.This is an example of ________.

The first step in assessing table structure is to count rows and examine columns.

A null value in a column may indicate that there is no appropriate value for that attribute.

Read-only databases are often updated.

The multivalued,multicolumn problem occurs when a set of columns are used to store data that should actually be in one column.

Most DBMS products will let you define a primary key on a column that contains null values.

The elimination of modification anomalies and the reduction of duplicated data are advantages of normalization.

When accessing table structure,and determining the number and types of columns in a table,how can you control how many rows are returned?

The SQL keyword TOP ________.