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_at_earthlinknet>
Date: Fri, 14 Dec 2007 20:11:59 -0500
Message-ID: <2007121420115916807-kirakun_at_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.
-- -kiraReceived on Sat Dec 15 2007 - 02:11:59 CET