Re: normalization review

From: Jan Hidders <hidders_at_gmail.com>
Date: Mon, 27 Aug 2007 07:51:46 -0000
Message-ID: <1188201106.545311.112130_at_o80g2000hse.googlegroups.com>


On 27 aug, 06:33, "landonkelsey" <u36972_at_uwe> wrote:
> 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

Since the location was described as precise I would presume there is also a FD L -> N with L being the location and N the number. In that case you are in 3NF, but not in BCNF.

  • Jan Hidders
Received on Mon Aug 27 2007 - 09:51:46 CEST

Original text of this message