Re: Primary-key ... alternate key ... (newbie question)
From: Jan.Hidders <hidders_at_hcoss.uia.ac.be>
Date: 7 Oct 2002 17:31:12 +0200
Message-ID: <3da1a8c0$1_at_news.uia.ac.be>
Date: 7 Oct 2002 17:31:12 +0200
Message-ID: <3da1a8c0$1_at_news.uia.ac.be>
In article <c0d87ec0.0210070709.47fcdf95_at_posting.google.com>,
--CELKO-- <71062.1056_at_compuserve.com> wrote:
>>> The attributes shall be depend of ALL the key's Nothing else than
>ALL the key's? <<
>
>That is Chris Date's short description of Third Normal Form (3NF).
Not BCNF? Because for 3NF it should read "The non-key attributes shall ..."
>The actual quote is "the key, the whole key and nothing but the key" which
>is a parody of the oath that witnesses take in a trial in the United States
>-- "Do you swear to tell the Truth, the whole Truth and nothing but the
>Truth, so help you God?"
.. and then it turns out that there is not always such a thing as *the* key. Go figure. :-)
- Jan Hidders