Database Design Using Normalization – True or False

11. The design guidelines and priorities for read-only databases are different because read-only databases are never updated.

A. True
B. False

Correct Answer:  A. True

12. The phrase “SALE.CNumber must exist in CUSTOMER.CNumber” is a referential integrity constraint.

A. True
B. False

Correct Answer:  A. True

13. We use the SQL construct COUNT(*) to count the number of rows in a table.

A. True
B. False

Correct Answer:  A. True

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

A. True
B. False

Correct Answer:  B. False

15. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

A. True
B. False

Correct Answer:  B. False

Leave A Comment?

5 + five =