Re: normalization question
From: toby <toby_at_telegraphics.com.au>
Date: Mon, 27 Apr 2009 17:12:14 -0700 (PDT)
Message-ID: <9537eaf6-4d8a-46a4-a248-b625465034c7_at_y6g2000prf.googlegroups.com>
Date: Mon, 27 Apr 2009 17:12:14 -0700 (PDT)
Message-ID: <9537eaf6-4d8a-46a4-a248-b625465034c7_at_y6g2000prf.googlegroups.com>
On Apr 27, 4:11 pm, myotheraccount <levt..._at_yahoo.com> wrote:
> That's similar to my first proposed solution, but, like that solution,
> does not enforce rule #3. For example:
> R1
> BoxID, CustomerID, VendorID
> 1, 1, 1
> 2, 1, 1
>
> R2
> BoxID, ItemID
> 1, 1
> 2, 1
>
> The keys will allow this, but it violates Rule #3
What if the key on R2 is {ItemID} alone? Received on Tue Apr 28 2009 - 02:12:14 CEST