Re: normalization review

"landonkelsey" <u36972_at_uwe> wrote:

>Did you read the original post where the composite primary key is defined?
>
>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!

     It can in the case of a cell phone. At 8 AM, the phone is in Kamloops. At 4 PM, it is in Seattle. This could affect billing big time.

     For that matter, a change order moving a landline from 567 Main St. to 789 Second St. could also apply. (I doubt that this would be tracked, but the client decides.) In this case, I doubt the call would be billed any differently if it is in the same exchange. If not, then it is a different phone number anyway.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.