Re: normalization review
Date: Mon, 27 Aug 2007 05:09:59 GMT
The location column does not depend on the ENTIRE primary key!
Bob Badour 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.
>>>2 is violated ...why?
>[quoted text clipped - 4 lines]
>>>>No form is violated.
Received on Mon Aug 27 2007 - 07:09:59 CEST