 |
Email me if you would like an Access Database.
The Specifications have been drafted by Scott.
If you new to Databases, you will find my new Tutorial helpful to Understand the Database Schema.
If you can see PF in the left-hand column of an Entity, such as Donations_to_Funds, it means that a Primary Key is also a Foreign Key to another Entity.
This usually appears as the result of the resolution of a Many-to-Many Relationship into two One-to-Many Relationships.
In this case, we can say that 'One Donation can be split among Many Churches' and 'One Church can receive Many Donations'.
|
Conceptual Data Model
The design here is slightly different to the Logical Data Model on the right.
|
Logical Data Model
|
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
|
