Re: Some Humor
From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Tue, 21 Jun 2005 05:22:12 GMT
Message-ID: <8uNte.7363$jX6.6924_at_newsread2.news.pas.earthlink.net>
>
>
> Pop-quiz! Does this describe 3NF or BCNF? Explain Why.
Date: Tue, 21 Jun 2005 05:22:12 GMT
Message-ID: <8uNte.7363$jX6.6924_at_newsread2.news.pas.earthlink.net>
Jan Hidders wrote:
> Dan wrote:
>
>> ThirdNormalForm: >> >> 1. The key >> 2. The whole key >> 3. And nothing but the key >> >> So help me Codd.
>
>
> Pop-quiz! Does this describe 3NF or BCNF? Explain Why.
BCNF.
IIRC, 3NF permits an FD that references part of a candidate key, and
therefore fails on the third point.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/
Received on Tue Jun 21 2005 - 07:22:12 CEST