Re: Treating addresses in 3NF?
From: Jan Hidders <hidders_at_REMOVE.THIS.uia.ua.ac.be>
Date: 17 Nov 2002 23:49:03 +0100
Message-ID: <3dd81cdf$1_at_news.uia.ac.be>
Date: 17 Nov 2002 23:49:03 +0100
Message-ID: <3dd81cdf$1_at_news.uia.ac.be>
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