Relations Question
Date: 2000/07/06
Message-ID: <8k295.165$B01.1001_at_client>#1/1
This has been hounding me for days... maybe yall can help. How would yall
model the following...
In the state of Texas, (Master) There are 25 Districts. The state's 254
counties are divided amoung those 25 districts. Then of ocurse the Cities
are in the counties. etc....
In the state of Alaska There are no district or "counties". They have
something like a county..but a different name.
In Alabama, the order is State, Division, District, County, City (And a
County may be contained in 2 districts.)
---- So you have State, District, County, City
---- So Its State, "County"
Other states are even more different..
What kinda structure would yall use to make quering things like The Cities
in a State... or other such items perform well?
Thanks,
I think one was State, Region, Division, District, County, City....
- Roger