Ways of validating data
For example, a secondary school student is likely to be aged between 11 and 16.
The computer can be programmed only to accept numbers between 11 and 16. However, this does not guarantee that the number typed in is correct.
Example: If a data type is set to be ‘numeric’, then all other types, such as a character(s) will be denied with an error.
Stromwall, both of Arizona State University's School of Social Work.The key factors in data integrity are constraints, referential integrity and the delete and update options.