Chapter 8 uses a simple order processing data structure to illustrate the use and workings of a database – the data structure is reproduced below.
The entities and relationships are:
This data structure has been implemented as a database – files are available for:
Developed on Access07 + tested on Access10.
Includes forma and reports but no program logic to allocate stock or to calculate invoices.
The scripts have been written for MySQL – an open source database that you can download for free (there are paid-for versions that you probably want to avoid). In theory the scripts should also work with other sql databases (Oracle, MS Access) but in practice you might have to make minor modifications. You are also welcome to amend / expand the scripts for your own purposes if you so wish.