Re: normalization review
Date: Mon, 27 Aug 2007 02:28:14 -0300
Once, but I forgot it.
> 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!
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.
>>>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:28:14 CEST