Re: normalization review
Date: Mon, 27 Aug 2007 07:51:46 -0000
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