Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Why 3FN is so strict?

Re: Why 3FN is so strict?

From: Jan Hidders <hidders_at_REMOVE.THIS.uia.ua.ac.be>
Date: 18 Nov 2002 00:10:05 +0100
Message-ID: <3dd821cd$1@news.uia.ac.be>


Juan Pardillos wrote:
>Hi,
>
>I don't understand why in 3NF an indirect dependency of a key
>attribute with respect to another key attribute is not considered a
>transitive dependency. That would imply that 3NF equals BCNF. I think
>is very strange the way in which the original definition of 3FN was
>limited.
>
>Any ideas?.

The magic word is "dependency preserving".

Received on Sun Nov 17 2002 - 17:10:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US