Re: Who first (publicly) asserted 3NF is "good enough"?
From: Jan Hidders <hidders_at_gmail.com>
Date: 19 Sep 2006 01:51:38 -0700
Message-ID: <1158655898.882558.208810_at_d34g2000cwd.googlegroups.com>
Date: 19 Sep 2006 01:51:38 -0700
Message-ID: <1158655898.882558.208810_at_d34g2000cwd.googlegroups.com>
Alfredo Novoa wrote:
> Bob Badour wrote:
>
> > Having a thorough understanding of 3nf may be good enough as long as one
> > also knows to open a reference text at the first hint of a complex
> > dependency or a compound key.
>
> I think that it is a lot better to use BCNF.
>
> BCNF is "better" than 3NF and even easier to check IMO.
Moving to BCNF you may no longer be "dependency preserving", so whether that is "better" or not may depend.
- Jan Hidders