[UPHPU] Database Question

[Webot Graphics]

> You should read up on first, second, and third level  
> normalization.  If you plan on creating databases at all, you  
> should do yourself the favor of understanding what normalization is.

Do you know of any good online articles for this?

> To answer your question it would be helpful to also know if each  
> separate size is also a different price. If so, then you may need  
> yet another table for prices for each product and each size of  
> product.

Yes, each size will have a different price.

> Are all products in the database like this?  Are all of them going  
> to follow the same pattern?

Almost all the products have multiple sizes, but not all of them will  
be available in the same sizes. For example we have some products  
that are only available in 1oz, 4oz, 8oz, and 16oz. There are also  
some products that don't have multiple sizes at all.

>
> Jonathan
>


Justin Giboney
graphics at westernbotanicals.com