[AccessD] Re: question on normalization

John Clark John.Clark at niagaracounty.com
Fri Mar 12 07:59:27 CST 2004


This is actually what I was looking at--keeping the zips and the towns
seperated. 
 
Maybe I'm a closet freak myself--hmmph!
 
John W Clark


>>> rl_stewart at highstream.net 3/12/2004 8:42:37 AM >>>

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 


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list