Re: normalization review

"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
> violation.
>
> 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.
>
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