An eTaxi company is recruiting staff in the age range 18-31. Potential recruits simply visit the company website and fill out the form. The company will send further details about the position at a later date.

Look at the form above. Try using it. What happens if:

• you don't enter a first name?
• you enter a number outside the range 18-31?
• the email address is not an email address?
• the password is too short or too long?

Yes, that's right! Databases can be programmed to accept valid data only!

Database engineers design data validation rules to help minimise the rick of invalid data entry. Here are some of the kinds of rules that can be designed:

1. format validation check
2. presence validation check
3. length validation check
4. range validation check
5. data type validation check

Using the form above, what kind of validation rule has been created for each data entry element?

   Skill-up 1 - Creating validation rules.

Research Data Validation for the database application you are using. Import the file below into your application and create validation rules. Test them by attempting to enter valid and invalid data into the database table.

data file

Be smart! Download the file and save it in a new project folder. Don't leave it in the downloads folder of your computer. You are not a newbie!

   Evidence

In your evidence document, paste a screenshot of each validation rule you designed, along with the name of the rule.