 |
An Access Database is available.
The Specifications have been provided in a question to Database Answers.
We would be glad to have
your comments.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
Our Best Practice recommends that a Conceptual Model is produced first, with involvement from the Subject Matter Experts and
then the more detailed Logical Data Model (ERD) is created.
This is a Business-oriented Conceptual Model
In this Model, arrows point from 'Children' to 'Parents'.
We have chosen not to show the 'Rabbits-Ear' or
Self-Referencing Relationship on the 'Expense Categories'
Entity to keep the diagram simple.
|
This shows the ERD for the Conceptual Model shown on the left
|
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
June 2nd. 2014
|
© DataBase Answers Ltd. 2014
|