Re: Treating addresses in 3NF?

From: Jan Hidders <>
Date: 17 Nov 2002 23:49:03 +0100
Message-ID: <3dd81cdf$>

David Cressey wrote:
>> So let's take a look at your
>> relation:
>> Customer(ID, Name, Address1, Address2, City, Zip_code )
>> How do we know that the two addresses have the same city and zip code? We
>> probably don't so let's fix that:
>PMFJI. Are you sure that Address1 and Address2 are not two lines on a
>single address?

My mistake, I had forgotten that British addresses are represented different than ours. Actually, there is also another error in the normalization process I described. There's bonus if you find it. ;-)

  • Jan Hidders
Received on Sun Nov 17 2002 - 23:49:03 CET

Original text of this message