Database Answers The White House

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
US Government Organization
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.

    Stage 1 Data Model for the structure of the US Government Organization.
  • 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 :-

    Stage 2 Data Model for the structure of the US Government Organization.
  • 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 :-

    Stage 3 Data Model for the structure of the US Government Organization.


    © DataBase Answers Ltd. 2009
  • Home Ask a Question Careers Contact us Data Models First Timers Search Site Map