| Validation and Verification : Range Check
| 
|
|
Range checks are validation checks
which are used on data made up of numbers or dates which must fall into a particular range.
A lower and upper boundary for sensible values is specified.
Any values which fall outside of this range will be rejected. Most sophisticated
databases will let you set valid ranges for each
field.
| Field Name |
Lower Boundary |
Upper Boundary |
| Age | 0 | 130 |
| Car Engine Size (L) | 0.5 | 8.0 |
| Month | 1 | 12 |
| Temperature in UK (C) | -20 | 40 |
Sometimes there is only one boundary required for a particular field. For example the minimum volume of a cube would
be zero cubic centimetres, but there is no maximum volume. When there is only one boundary to check the type of
check used is known as a limit check rather than a range check.
GCSE ICT Companion 04 - (C) P Meakin 2004