Data Validation and Verification Flashcards
What is data validation?
Validation is an automatic computer process of ensuring that the input data supplied to a system satisfies a set of rules such that it is sensible, complete, reasonable and within acceptable boundaries. It does not check the accuracy of data.
What are the types of validation?
Presence check, type check, range check, length check, format check and check digit.
What is presence check?
It ensures the data is entered and all necessary fields are present. It can prevent receiving partial information which cannot be rectified later.
What is type check?
It ensures that the data is of a suitable data type.
What is length check?
It ensures that the data has the expected number of characters.
What is range check?
It ensures that the data is scoped within an expected pre-determined boundary.
What is format check?
It ensures that the data matches a required arrangement or pattern. This checks that the data is of the right format, that it is made up of the correct combination of alphabetical and numeric characters.
What is check digit?
Check digit allows the data to be self-checking. The check digit is a single digit added to the code number. The check digit is calculated using a specified algorithm that uses values and weights of the digits in the data from other digits in the number.
What is data verification?
Data verification is performed to ensure that the data entered matches the original source exactly. It does not check the accuracy of data.
What are the types of verification?
Double entry, proofreading
What is double entry?
It consists of entering the data twice and comparing both copies.
What is proofreading?
It consists of having a person check the data entered against the original document.
What are the types of error made?
Transcription error and transposition error
What is transcription error?
A transcription error is a specific type of data entry error that is commonly made by human operators or optical character recognition programs. Human transcription errors are commonly made by the result of typographical mistakes.
e.g. gtegory instead of gregory
What is transposition error?
Transposition errors occur when characters have switched places. They are almost always human in origin.
e.g. gergory instead of gregory