Re: Help w/ Normalization?

You could add a new table, but you said it yourself "They are all the same SKU, but with a slightly different extention". Thus they are not the same sku number and no need to normalize this.

nkaiser_at_my-deja.com wrote in message <88csht$9sk$1_at_nnrp1.deja.com>...
>I'm looking for some approaches to the best design for the following
>problem:
>
>Previously, I had an INVENTORY table. Basic stuff:
>
>SKU
>QUANTITY
>DESCRIPTION
>PRICE
>WEIGHT
>
>Now, there's a new twist. An item can have multiple sizes and/or
>multiple colors and/or any other attribute. But the tricky part is
>that I need to associate a quantity with each combination.
>
>Let's say we are dealing with T-Shirts. I have 10 total. 3 M green. 4 L
>blue, and 3 L white.
>
>They are all the same SKU, but with a slightly different extention.
>
>I don't want to have to repeat the INVENTORY.description for each
>shirt. Because they are exactly the same, just a different size/color,
>and/or price/weight. FOr example, an XXL could be an additional $5.
>
>I'm sure this is a very common problem. Can someone give me some
>insight or point me to an article.
>
>Thanks alot.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Feb 20 2000 - 00:00:00 CET