Validation+Questions

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

2. Describe what is meant by a presence check

3. Describe what is meant by a range check

4. Describe what is meant by a restricted choice check

5. Describe what is meant by a field length check

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

(a) Suggest a suitable validation check for the Date Sold field (b) Suggest one field which should have a presence check (c) Suggest one field which does not need a presence check

7. 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 Sex field. Explain your choice for each.

8. Duncastle United Football Club runs a membership scheme for fans, as shown below. When the club secretary tries to enter this record, they get an error message. Explain why the error message has appeared and what the secretary should do to resolve the problem.

9. Suggest suitable field length limits for the following fields: (a) Forename (b) Surname (c) Address (d) City (e) Annual salary