Re: normalization review

From: Jan Hidders <>
Date: Mon, 27 Aug 2007 07:51:46 -0000
Message-ID: <>

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