> 1 the main table contains the address itself, and pointers to the city, 
> and the state tables.
>
> That's right, a row for every city, and a row for every state.

That seems fine to me, for one thing it avoids people making a typo on the 
state, which makes doing things by state harder later on.  Not so sure about 
the city, I don't know how it works in the US, but in the UK you might not 
officially be living in a city, and then your "city/town/village" table is 
going to be HUGE with basically every little place in it, and there are 
duplicates in different parts of the country!

Post a reply to this message