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: Help needed on Boyce-Codd Normal Form.

Re: Help needed on Boyce-Codd Normal Form.

From: Kira Yamato <kirakun_at_earthlink.net>
Date: Fri, 14 Dec 2007 20:11:59 -0500
Message-ID: <2007121420115916807-kirakun@earthlinknet> 





On 2007-12-14 12:06:39 -0500, "Knowledgy" <knowledgy_at_knowledgy.org> said:



> You must resolve the many-to-many relationships.  You'll need to create 

> an additional table (known as an intersection table) to handle the 

> constraints you mention.  The intersection table will control 

> constraints 1 and 2 in your post




The problem is that I cannot identify relations for this intersection 
table that is of BCNF.



Everything I've tried is at best 3NF.


-- 

-kira


Received on Fri Dec 14 2007 - 19:11:59 CST












Original text of this message













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