ISDD+Database+Validation

media type="custom" key="28063739"


 * Questions**

1. What is meant by the validation of a database field?

2. Explain using an example why validation cannot prevent all erroneous data input.

3. In your own words, state what is meant by the following types of data validation: (a) Presence check (b) Range check (c) Restricted choice check

4. A car showroom keeps a database of all the cars which have been sold. An extract from the database is shown below:

(a) Identify 2 fields which should have a presence check and explain your decision (b) Identify 2 fields which should have a range check, and suggest the lower and upper values that should be used for each (c) Identify 2 fields that should have a restricted choice check and suggest a list of acceptable values for each

5. Download the Car Showroom database and apply the validation checks you selected in question 4

6. A school office keeps a database of all of the pupils at the school, as shown below:

State 2 validation checks which might be used on the Gender field. Explain your choice for each.

7. David is updating a database on football players. He gets a validation error message when entering the data below. Explain why he gets each error and identify the validation check used.

(a)

(b)