Re: Newbie question about db normalization theory: redundant keys OK?

On Sat, 15 Dec 2007 09:54:11 -0400, Bob Badour wrote:

>
>6NF:
>R1(a*,b)
>R2(a*,c)
>
>6NF has at most one non-key attribute.

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)
R2(b*,c*,d)

Best, Hugo Received on Sat Dec 15 2007 - 16:36:43 CST