Critical Thinking Questions
Case 11-2
In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data.
-The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?
A) completeness check
B) range check
C) consistency check
D) check digit

Question

Quizplus · Accepted Answer

A completeness check would be the best choice to identify the records with no data in the city field. This type of check ensures that all required fields are filled in and that no values are missing. It will help restore the integrity of the data by ensuring that every record in the database has a value in the city field.

Critical Thinking Questions Case 11-2