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_at_news.uia.ac.be>
Date: 18 Nov 2002 00:10:05 +0100
Message-ID: <3dd821cd$1_at_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".
- Jan Hidders