Exam 4: Database Design Using Normalization

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

A null value can indicate which of the following conditions?

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

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

The SQL function COUNT ________.

What is the multivalue,multicolumn problem,and why is it a problem? Include an example.

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 ________.

A null value in a column may indicate that there is an appropriate value for that attribute,but it is unknown.

SQL statements that can be used to create referential integrity statements for normalized tables are created during the normalization process.

Design guidelines and priorities are the same whether you're working with an updatable database or a read-only database.

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

To check for null values in a column in a table,use the SQL phrase ________.

When examining data values as a part of assessing table structure,there is no need to try to determine foreign keys.

The presence of one or more foreign keys in a relation prevents ________.

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

United States ZIP codes are a classic example of unneeded normalization.

To eliminate multivalued dependencies,normalize your tables so that they are all in BCNF.

What are general-purpose remarks columns,and why are they a problem?

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

Denormalization is simple-join the data together and store it in a table.