| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Who first (publicly) asserted 3NF is "good enough"?
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.
![]() |
![]() |