Re: normalization review
Date: Mon, 27 Aug 2007 13:21:47 GMT
"landonkelsey" <u36972_at_uwe> wrote in message news:774e2b6d6d89a_at_uwe...
> Did you read the original post where the composite primary key is defined?
Please do not top post.
> Having one phone have a number of lines has no impact on the normalization
> 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
> >> 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.
There was an error in the original post. The components of the PK are described as "candidate keys". They are not. Received on Mon Aug 27 2007 - 15:21:47 CEST