Re: normalization question

From: Matko <mklaic_at_foi.hr>
Date: Tue, 28 Apr 2009 11:10:31 +0200
Message-ID: <gt6h4l$k0a$1_at_ss408.t-com.hr>



ItemID can't be primary key because its value in every entry is not unique ;)

Matko

"toby" <toby_at_telegraphics.com.au> wrote in message news: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 - 04:10:31 CDT

Original text of this message