Re: Primary-key ... alternate key ... (newbie question)

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