Data integrity is the state of data being as it should be, reflecting reality.
1 of 9
What are the types of validation check?
Check Digit, Format Check, Length Check, Lookup Check, Presence Check, Range Check and Type Check
2 of 9
Explain what check digit is.
Check digit- A calculation is performed on a number which generated another digit which is added ti the number. When the data is entered, the calculation is repeated and if it doesnt generate the same check digit, the input is rejected.
3 of 9
What are some examples of uses of check digit?
Account Numbers, Bar Codes and book ISBNs
4 of 9
Explain what format check is.
Format Check- The data may have to conform to a certain pattern. E.g. Car Registration Plates
5 of 9
Explain what Lookup Check is.
Lookup Check- Some fields may be looked up to see if they are from an allowed range. (e.g. Postcodes)
6 of 9
Explain what Presence Check is.
Presence Check- This is to ensure that all important information has been included. (e.g. a bank application needs a surname)
7 of 9
Explain what range check is.
Range Check- A number must fall within limits (e.g. theatre tickets may be limited to 2 per person)
8 of 9
Explain what type check is.
Type Check- The data type may be restricted (e.g. no numbers in a surname)
9 of 9
Other cards in this set
Card 2
Front
What are the types of validation check?
Back
Check Digit, Format Check, Length Check, Lookup Check, Presence Check, Range Check and Type Check
Comments
No comments have yet been made