[AccessD] Re: question on normalization

John,

I have a table for the US with all that
in it.  Do you need it?

For the normalization freaks (like me),
here is a normalized design:

tblPostalCode
PostalCodeID  AutoNumber (PK)
PostalCode    Text(10)
CityID        Long Integer
RegionID      Long Integer

Unique index on PostalCode, CityID, RegionID

tblCity
CityID        Autonumber (PK)
CityName      Text(30)

Unique Index on CityName

tblRegion
RegionID      Autonumber (PK)
RegionName    Text(30)
CountryCode   Text(2)

Unique Index on RegionName, CountryCode

tblCountry
CountryCode   Text(2) (PK)
CountryName   Text(30)

Unique index on CountryName


Robert

P.S.  The ISO standard is actually Division, if I remember
correctly for the way I used region here.

At 07:10 PM 3/11/2004 -0600, you wrote:
>Date: Thu, 11 Mar 2004 16:55:17 -0500
>From: "John W. Colby" <jwcolby at colbyconsulting.com>
>Subject: RE: [AccessD] question on normalization
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <DCEFJAOENMNENLAAOFGPCEJAHCAA.jwcolby at colbyconsulting.com>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>David,
>
>Did you fill in this table with which Zips were in which town etc.?  Or is
>there a standard db out there somewhere with this stuff?
>
>John W. Colby
>www.ColbyConsulting.com