An Access Database is available on demand.
Specifications have been drafted in a question to the Database Answers Web Site.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
There might also be a design for a Data Warehouse, which might very useful for providng data for Reports and Business Intelligence.
But it is hard to see a real use for one in this (exceptional) case so it is unlikely.
If you have any comments on the Data Model, we would be pleased to
hear from you.
Database Answers Ltd.
August 17th. 2012
© DataBase Answers Ltd. 2012