![](../../images/spacer.gif) |
You can email me if you would like an Access Database.
The Specifications have been provided in a question to the Database Answers Community.
A Data Mart has been designed to provide a starting-point for Enquiries and Reports.
If you are new to Data Models, this page of my new Tutorial will help you
understand the Data Model.
The broken line between Products and Subscriptions shows that the
Product_ID field in the Products table appears as a Foreign Key in the Subscriptions table.
The continuous line between Products and Product_Suppliers shows that the
Product_ID field appears as a Primary Key in the Subscriptions table.
If you are not clear about exactly what are Primary and Foreign Keys then take a look
at this Chapter in my Tutorial of Understanding a Data Model.
Barry Williams
February 23rd. 2011
Database Answers Ltd.
London, England
|
|