Critical Thinking Questions Case 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) consistency check
C) alphabetic check
D) check digit

Question

Quizplus · Accepted Answer

An alphabetic check would be the best choice because it can verify if the data in the First Name field contains only letters. The numbers and asterisk would be flagged as invalid data. A completeness check would verify if the field is filled out for all records, while a consistency check would ensure that the First Name field is consistent across all the records. A check digit is used to verify the accuracy of numeric codes, so it would not be applicable in this case.

Critical Thinking Questions Case 2 in Your Database Course, Your