Re: normalization review
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 27 Aug 2007 01:50:59 -0300
Message-ID: <46d257e9$0$4064$9a566e8b_at_news.aliant.net>
>
>
Received on Mon Aug 27 2007 - 06:50:59 CEST
Date: Mon, 27 Aug 2007 01:50:59 -0300
Message-ID: <46d257e9$0$4064$9a566e8b_at_news.aliant.net>
landonkelsey wrote:
> location depends only on the telephone number not on the entire primary key
>
> However if the telephone were a cellphone, there would be no violation!
>
> Look at the Boyce Codd normalization principle
Without having ever specified a PK, the above doesn't make much sense.
Location does not depend on the phone number in many offices with PBX systems. Any phone can make and receive calls on any line.
> landonkelsey wrote:
>
>>2 is violated ...why? >> >> >>>>What normal form is violated here? >>>>What could fix the problem? >> >>[quoted text clipped - 3 lines] >> >>>No form is violated.
>
>
Received on Mon Aug 27 2007 - 06:50:59 CEST