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
