Trusted by millions of Kenyans
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Explain the main types of validation checks that may be used on data

Explain the main types of validation checks that may be used on data

Answers


Steve
Presence - Data are checked to ensure that all fields are present.
Size - Fields are checked to ensure that they contain the right number of characters.
Range - Number of codes are checked to ensure that they are within the permissible range.
Character check - Fields are checked to ensure that they contain only characters of the correct type e.g. no letters in numeric field.
Format - Fields are checked to ensure that they are of the correct format.
Reasonableness - Quantities are checked to ensure that they are not abnormally high or low.
Check digits – Use of a check digit enables a number to be self-checking. It’s a means of ensuring that a number (e.g. a customer account number) maintains its validity.


Steve ju answered the question on June 7, 2018 at 18:19

Answer Attachments

Exams With Marking Schemes

Related Questions