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
Advertisement

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

A. True
B. False

Correct Answer:  A. True
Advertisement

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

A. True
B. False

Correct Answer:  A. True
Advertisement

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
Advertisement

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
Advertisement

Leave A Comment?