Re: normalization review
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Sun, 26 Aug 2007 23:34:15 -0300
Message-ID: <46d237dd$0$4059$9a566e8b_at_news.aliant.net>
Date: Sun, 26 Aug 2007 23:34:15 -0300
Message-ID: <46d237dd$0$4059$9a566e8b_at_news.aliant.net>
landonkelsey wrote:
> 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)
Good luck with the homework assignment! Received on Mon Aug 27 2007 - 04:34:15 CEST