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
Advertisement

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
Advertisement

18. Normalization requires programmers to write more complex SQL.

A. True
B. False

Correct Answer:  A. True
Advertisement

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
Advertisement

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
Advertisement

Leave A Comment?