1j Validation Methods *** Flashcards
Miss Jones is going to enter the data she has collected into a spreadsheet so that she can analyse it.
(a) The data needs to be validated.
What is the purpose of validation? (1 mark)
One from:
To make sure the data is sensible (1)
To make sure the data is reasonable (1)
To make sure the data is in the right format (1)
To make sure the data conforms to rules (1) [1] To make sure the data is within set boundaries (1).
Identify and describe two different validation routines that could be used for the telephone number field (2 marks)
2 from, 2 marks each. 1 for identification, 2nd for description.
Length check (1) ensure it cannot exceed maximum number of digits (1)
Format/picture check/input mask (1) make sure that only numbers are entered (1)
Presence check (1) to make sure something has been entered (1)
Describe two different validation methods suitable for a telephone number.(4 marks)
1st for identification, 2nd for description/example 2 from: Presence (1) makes sure a phone number has been entered (1) Length (1) makes sure enough numbers entered (1)
Picture/format (1) only numbers can be entered (1).
A bookshop has a database which includes details of books.
(a) Describe the following validation methods and give an example of where each could be used
Lookup (3 marks)
Check Digit (3 marks)
3 marks each, 1 for example of use:
Lookup: based on a value cross referencing (1) and returning a
single value/list of values (1)
Example: eg lookup book titles based on author/lookup titles
based on genre (1)
Check digit: mathematical calculation (1) that results in a single number to compare (1)
Example: eg checking ISBN number on book (1)