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@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 - 00:22:12 CDT