Re: Newbie question about db normalization theory: redundant keys OK?
From: David Cressey <cressey73_at_verizon.net>
Date: Sat, 15 Dec 2007 14:07:15 GMT
Message-ID: <ncR8j.287$qv1.250_at_trndny01>
Date: Sat, 15 Dec 2007 14:07:15 GMT
Message-ID: <ncR8j.287$qv1.250_at_trndny01>
"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message news:4763dc87$0$5291$9a566e8b_at_news.aliant.net... [snip]
> 6NF:
> R1(a*,b)
> R2(a*,c)
>
> 6NF has at most one non-key attribute.
Thanks for the above definition. It's simple, and easily understood. I actually "invented" this form on my own in my head, but didn't think it was important enough to merit giving it a name.