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>
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