Back to the Data Model.
The Area being Modelled is :-
The Organization and structure of the US Government
Here's an Organization Chart from Washburn University School of Law :-
A. THE USER REQUIREMENTS :
I was looking at your data models list, trying to determine which data models to study... to start from.
I'm trying to design a database to reflect the positions that US voters can choose candidates for.
I started thinking through the organization of the government.
So far, I'm looking at a fairly huge datastore for the structure alone.
My prelinimary design (so far) is one table to hang the goverment's structure on.
I'm thinking that I can point names and addresses to the structure, but I'm just trying to define the
structure at the moment.
1) FedFlg bit (T=Federal, F=State) ** Is this a Federal position ?
2) BranchFlg bit (T=Executive,F=Legislative) ** Is this an Executive position ?
3) LevelFlg bit (If Federal
4) Indice integer (For Senators, 0/T=Senior Senator, -1/F=Junior Senator)
(For House, 999=District)
5) ZipCode integer5 Zip of home/central office
Are there any designs that I should study for ideas, or is there a design specifically about US government
structure that I should look at?
B. THE APPROACH :
The Approach was to start with a general Hierarchical Data Model.
C. The Things of Interest
C.2 Organization Units
© DataBase Answers Ltd. 2009