An Access Database is available on demand.
The User Requirements have been defined.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
There are three diagrams on this page.
The purpose of these diagrams is to explore ways to model the structure of the US Government Organization in a manner that is both economical and realistic.
We also aim to make it clear the design process so that it can be understood by other people.
These Models has been produced from a review of the Organization Chart published by Washburn University Law School, which is on the User Requirements page.
The Stage 1 Model
Our starting-point was that all organisation structures are hierarchical and can therefore be modelled very simply using a reflexive ('rabbits-ear') approach.
The Stage 2 Model
This adds Roles at each Level, and, of course, there can be many Roles at each Level so we have a many-to-many relationship that we resolve :-
The Stage 3 Model
Thisadds People for each Role and again there can be many People in each Role so we have another many-to-many relationship that we resolve :-
© DataBase Answers Ltd. 2009