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>



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 Mon Apr 27 2009 - 19:12:14 CDT

Original text of this message