Re: normalization review
From: Evan Keel <evankeel_at_sbcglobal.net>
Date: Sun, 26 Aug 2007 23:30:53 -0400
Message-ID: <3ArAi.4676$Oo.3338_at_newssvr17.news.prodigy.net>
Date: Sun, 26 Aug 2007 23:30:53 -0400
Message-ID: <3ArAi.4676$Oo.3338_at_newssvr17.news.prodigy.net>
"landonkelsey" <u36972_at_uwe> wrote in message news:774cc329c1476_at_uwe...
> What normal form is violated here?
> What could fix the problem?
>
> 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)
>
No form is violated. Received on Mon Aug 27 2007 - 05:30:53 CEST