Re: normalization review

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.