Re: normalization review
Date: Mon, 27 Aug 2007 16:25:59 GMT
Larry Coon wrote:
>> What normal form is violated here?
>Since you've provided an imprecise description without
>elaborating the FDs, I don't think it's possible to
>You might be implying an FD from telephone number to
>telephone location, but I certainly wouldn't take it
>as a given. For example:
>1. A cell phone can be at any location.
>2. A land line might be given up by one customer, and
> later reassigned to a new customer.
>> What could fix the problem?
>A more precise description of the problem. It's
>certainly not at the point where a database developer
>could begin to develop a schema -- so why then would
>you think it's at a point where one could normalize it?
>> A telephone call is uniquely identified by telephone number and time of call.
>> These candidate keys compose the composite primary key. There is another
>> attribute/column âtelephone locationâ.
>> telephone number | time of call | telephone location(precise)
>University of California
-- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/db-theory/200708/1Received on Mon Aug 27 2007 - 18:25:59 CEST