Database Answers The White House

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
US Government Organization
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. GovStruct 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 If Executive, T=Pres, F=VP else T=Senate, F=House) (If State If Executive, T=Gov, F=LtGov else T=Senate, F=House) 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? Thank you, Barry S.
B. THE APPROACH :
The Approach was to start with a general Hierarchical Data Model.

C. The Things of Interest
C.1 Organization
C.2 Organization Units
C.3 People
C.4 Roles



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