Exam 4: Database Design Using Normalization

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

When examining data values as a part of assessing table structure,you should try to determine the table's primary key.

The advantages of normalization include ________.

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

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

A defining requirement for BCNF is that every determinant must be a candidate key.

The SQL function COUNT ________.

Relations are sometimes left unnormalized to improve performance.

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

If you have a table with a set of columns named "Child01","Child02" and "Child03",the table has the multivalued,multicolumn problem.

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

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

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

The standard sales order/line item pattern is a classic example of unneeded normalization.

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

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

Reviewing the work done on a table that was created using existing data from multiple sources,you find that a column name Remarks has been included,and it is populated with inconsistent and verbose verbal data.This is an example of ________.

The second step in assessing table structure is to examine data values and determine dependencies and keys.

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

Multivalued dependencies show up under a different name as the multivalued,multicolumn problem.