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.
-A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?
A) completeness check
B) alphabetic check
C) consistency check
D) check digit

Question

Quizplus · Accepted Answer

Since the First Name field should only contain alphabetic characters, an alphabetic check is necessary to ensure that the data is valid. The completeness check would only check if a value is present in the field, which does not address the issue of invalid characters. The consistency check would ensure that the data in the First Name field is consistent across all records, but would not address the issue of invalid characters. A check digit is used to verify the correctness of numerical values, not alphabetic characters.

Critical Thinking Questions Case 11-2