Validation

Validation
Validation is the process of ensuring that data entered into a database meets a certain rule or rules. There are different types of validation checks which can be performed on a database:


 * Presence check** - does the field have to have a value entered?


 * Restricted choice check** - the value entered has to be of a certain value (e.g. Mr / Mrs / Miss / Ms)


 * Range check** - the value entered has to fall within a certain range (e.g. 0-100)


 * Field length check** - specifies the maximum number of characters that a field can hold

Validation video
media type="youtube" key="KAJSjmNPGUk" width="560" height="315"

Tasks
1. Validation questions

2. Practical validation of school computers database