Re: Newbie question about db normalization theory: redundant keys OK?
From: Hugo Kornelis <hugo_at_perFact.REMOVETHIS.info.INVALID>
Date: Sat, 15 Dec 2007 23:36:43 +0100
Message-ID: <bdl8m3tv1ucqf11fp4sak24chm226s7q0a_at_4ax.com>
Date: Sat, 15 Dec 2007 23:36:43 +0100
Message-ID: <bdl8m3tv1ucqf11fp4sak24chm226s7q0a_at_4ax.com>
On Sat, 15 Dec 2007 09:54:11 -0400, Bob Badour wrote:
>
Hi Bob,
Isn't the latter statement an oversimplification? Unless I am truly
misunderstanding 6NF, I'd say that the scema below is 6NF even though R1
has two non-key attributes:
R1(a*,b,c)
>6NF:
>R1(a*,b)
>R2(a*,c)
>
>6NF has at most one non-key attribute.
R2(b*,c*,d)
Best, Hugo Received on Sat Dec 15 2007 - 23:36:43 CET