TEACHER NOTES

Database design unit requires the student to create a relational database.

The write-up must contain the following.

Introduction
Introduction to the present problem and the way the system is currently run. The outline the objective for the database solution which you are to develop for the end-user.

Design
Details of the database design which include indepth descriptions of table structure, query that will be required, forms and layout, reports that will be required, macros that will need to be programmed.

Implementation
This is a series of screendumps of the final database solution. Each screendump will be annotated explaining the features or programming involved.

Testing Plan
The database solution needs to be tested. Alpha testing is where the programmer enters normal data, extreme data (e.g. 1000% for a VAT rate) or erronous data (e.g. a postcode entered in the telephone field), tries the macros to see if they perform the correct function. Beta testing is where a user tries the system to find errors.

User Guide
A guide that intructs the user to load, navigate around the system, perform system operations, print reports, search for data, exit program.

Evaluation
A frank and open evaluation of the final solution highlighting the good points, bad point, difficult areas that were overcome, new database techniques you used. Finally, suggest any future developments that could be incorporated in the database application that could realistically be implemented and improve the database application as a whole.

Another Write-up Guide (BJW)
Another write-up guide with a helpful glossary of database terms to use. Recommended if you required a Merit or a Distinction Grade.

Update Query Guide
A guide to implement a update query into your project. An update query allows you to

• copy data from one table to another.
• calculate a value from existing data and place in a table. e.g net costs
• change a value from one setting to another. e.g. a YES to a NO