Re: Who first (publicly) asserted 3NF is "good enough"?

"Jan Hidders" <hidders_at_gmail.com> wrote in message news:1158656163.402734.26160_at_e3g2000cwe.googlegroups.com...
>
> -CELKO- wrote:
> >
> > And, as Bob pointed out, for a lot of commercial apps, there is an
> > industry standard or internally defined key that you have to use (UPC,
> > EAN, VIN, ISBN, etc.), so most of the tables have a simple key. Also,
> > if a table is all key, then it is in 5NF.
>
> What exactly do you mean by "a table is all key"? Is it "every column
> is by itself a candidate key" or "all columns together are a candidate
> key"? In the first case you are right, but in the second case your
> statement would not be correct.
>
> -- Jan Hidders
>

I take "all key" to mean that there is no candidate key other the entire relation. Received on Tue Sep 19 2006 - 14:18:23 CEST