Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Treating addresses in 3NF?

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@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. ;-)

Received on Sun Nov 17 2002 - 16:49:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US