Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Who first (publicly) asserted 3NF is "good enough"?

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

Received on Tue Sep 19 2006 - 03:51:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US