Please enable JavaScript.
Coggle requires JavaScript to display documents.
Validation and Verification (Validation (Different validation checks…
Validation and Verification
Validation
What is it?
Checks wether something is valid
Different validation checks
Range check
Checks if something falls into a certain range
Presence check
Checks if something has been added into somewhere
Length check
Checks if something is above/ below a certain number
Data type
Checks the type of data
Lookup
In a spreadsheet is is known a VLOOKUP (Vertical)
In a database it is HLOOKUP (Horizontal)
It represents inputting incorrect data.
Format check
Checks if something is in the correct format
Verification
What is it?
It verifies data to see if it is right
Ways to verify data
Proof reading
Reading over what has been wrote, allows the person writing it to see if they did type it in correctly
Sending back printouts
Sending back printouts to someone for them to be able to proofread what has been wrote
Double keying/ double entry
Makes you type in something twice in order to verify if they are both the same
Obfuscation
What is it?
this type of action makes the data obscure in order for it to be less easy to read
Example:
The you have entered card details into something and it saves, then the first 12 digits will show up as *, and the last 4 digits will show up as normal.