Exam 4: Database Design Using Normalization

The problem of misspelled data entries is really the same as ________.

The first step in assessing table structure includes ________.

Read-only databases often use several copies of a set of same data,where each copy is modified for a specific use.

Relations in BCNF have no modification anomalies in regard to functional dependencies.

The third step in assessing table structure is to check the validity of presumed referential integrity constraints.

To limit the number of rows retrieved from a table,use the SQL construct ________.

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

When examining data values as a part of assessing table structure,you should try to determine two types of dependencies: multivalued dependencies and 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 ________.

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

You are creating a PRODUCT table using existing data from multiple sources.Examining the data,you find that you have "large red hat","large hat,red","red hat large" and "hat,large,red." This is an example of ________.

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

A form of multivalued dependency is found in ________.

General-purpose remarks columns rarely contain important data.

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

The defining characteristic of BCNF is that a table is in BCNF if ________.

Creating a read-only database is a job often given to beginning database professionals.

When examining data values as a part of assessing table structure,there is no need to try to determine candidate keys other than the table's primary key.

The SQL function COUNT ________.

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