Exam 4: Database Design Using Normalization

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

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

Read-only databases seldom use more than one copy of a set of the same data.

A table with columns PhoneNumber01,PhoneNumber02,and PhoneNumber03 is likely to have ________.

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

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

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

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

Reviewing the work done on a table that was created using existing data from multiple sources,you find that a column named 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 includes ________.

Relations are sometimes left unnormalized to improve performance.

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

The advantages of normalization include ________.

Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.

The problem with a general-purpose remarks column is that the data it contains are likely to be verbal,inconsistent,and stored in a verbose manner.

A null value in a column may indicate that there is an appropriate value for that attribute,and although the value is known,no one has entered the value into the database.

Denormalization reduces the complexity of the SQL statements needed in an application to read required data.

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

A form of multivalued dependency is found in ________.

When a table is created using existing data,you are likely to find that some data values have never been provided because any value there would be inappropriate.This is an example of ________.