A DATA MODEL FOR THE US GOVERNMENT

  • The Stage 1 Model
    This shows only our starting-point was that all organisation structures are hierarchical and can therefore be modelled using a reflexive ('rabbits-ear') approach.

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

    © DataBase Answers Ltd. 2009