Exam 4: Database Design Using Normalization

The disadvantages of normalization include ________.

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 first step in assessing table structure includes ________.

You are creating a BOAT table using existing data from multiple sources,and you find that you have "power boat blue","boat,power,blue" and "blue power boat" as data values for the same column.This is an example of the inconsistent values problem.

One situation created by the multivalued,multicolumn problem is that the maximum number of data values for an attribute is limited.

The presence of one or more foreign keys in a relation means that we cannot eliminate duplicated data in that table.

General-purpose remarks columns rarely contain important data.

You have been given two tables,CUSTOMER and SALE.You want to check the referential integrity constraint: SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber You run the following SQL query: SELECT CustomerNumber FROM SALE WHERE CustomerNumber NOT IN (SELECT CustomerNumber FROM CUSTOMER); What is shown in the results of this query?

Read-only databases are often updated.

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

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

When a table is created using existing data from multiple sources,you are likely to find that some data values have never been provided because the values are not known.This is an example of ________.

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

Normalization is an advantage for a read-only database.

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

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

A missing value is called a null value.

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

An advantage of denormalization is ________.

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