Five-A-Day

Fruit & Veg Database Checklist

Have I checked that every field in my database has the correct name, type, format and length?

Have I made sure that my validation rules are correct?

Have I only validated items where I know exactly what is acceptable?

Did I create the database structure with validation before I imported the data?

Did I ask others to test my database structure before importing the data?

Have I found accurate information for five new records?

Have I added five new records without errors?

Have I stored evidence of my database structure and validation plus the five new records?

Back to Database