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.
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