Hi,
I'm creating a simple Country/State/City/Street database as a test bed for other applications. The Country/State/City/Street are each their own tables. State has StateID(PK), StateName and CountryID(FK). City and Street are identical (they only hold the ID(FK) for direct parent).
On the...