Database Design Using Normalization – True or False

16. One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.

A. True
B. False

Correct Answer:  A. True

17. One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.

A. True
B. False

Correct Answer:  B. False

18. Normalization requires programmers to write more complex SQL.

A. True
B. False

Correct Answer:  A. True

19. One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

A. True
B. False

Correct Answer:  A. True

20. When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.

A. True
B. False

Correct Answer:  B. False

Leave A Comment?

20 − 11 =