FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Database Design Using Normalization

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

A missing value is called a null value.

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

A classic example of unneeded normalization is when we are dealing with ________.

A) ZIP codes
B) sales orders and line items
C) association patterns
D) multivalued dependencies
E) general purpose remarks columns

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

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

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

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

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.

When you are creating a database from existing data,you will have only minor problems with inconsistent values.

To count the number of rows in a table,use the SQL construct COUNT(ROWS).

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

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

Read-only databases are often updated.

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

The second step in assessing table structure includes ________.

The advantages of normalization include ________.

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

When accessing table structure,how do you determine how many rows are in a table?

When a table is created using existing data from multiple sources,you are likely to find that some data values that have never been provided are simply and obviously wrong and inappropriate.This is an example of ________.

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 SALE,CUSTOMER WHERE SALE.CustomerNumber = CUSTOMER.CustomerNumber) ; What is shown in the results of this query?

When accessing table structure,how do you determine the number and types of columns in a table?