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

Home -> Community -> Usenet -> comp.databases.theory -> 3NF but not BCNF

3NF but not BCNF

From: Phil Cook <pacookSPAM_IRIS_at_blueyonder.co.uk>
Date: Tue, 15 May 2001 10:09:41 GMT
Message-ID: <Ff7M6.8074$zq2.600444@news1.cableinet.net>

I am presented with the following question:

    Argue that if a relation schema R is in Third Normal Form but not in Boyce-Codd

    Normal Form with respect to a set of functional dependencies F, then it must have

    at least two distinct keys for R with respect to F which overlap, i.e. such that their

    intersection is nonempty.

Unfortunately, my textbook only mentions this point in passing, referring to some paper by Vincent and Srinivasan. This paper does not appear to be available online, however.

Any explanation would be greatly appreciated. Received on Tue May 15 2001 - 05:09:41 CDT

Original text of this message

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