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

From: Hugo Kornelis <>
Date: Sat, 15 Dec 2007 23:36:43 +0100
Message-ID: <>

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

>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:


Best, Hugo Received on Sat Dec 15 2007 - 23:36:43 CET

Original text of this message