Re: normalization review

landonkelsey wrote:

> Did you read the original post where the composite primary key is defined?

Once, but I forgot it.

> 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!

Did you read where I observed that *any* phone can make and receive calls on any line? The location of the phone would depend on both the phone number for the line and the time. At a different time, someone at a different location could make or receive calls on the same number.

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