[UPHPU] Database Question

[Scott Hill]

On 8/14/06, Webot Graphics <graphics at westernbotanicals.com> wrote:
>
> > My $.02:
> > One table: unique_id, product_name, category, size, qty, price,
> > etc....
> >
> > It stays simple that way. So you have to enter Vanilla Extract 5
> > times, but that happens once. From then on, you have a lightweight,
> > straightforward, yet powerful system for your users (and the server
> > too I guess).
> >
> > Timothy
>
> I see your point. Each product would also have to have an amount for
> inventory purposes, which is the main reason I am not sure if
> multiple tables will work.
>
> Justin Giboney
> graphics at westernbotanicals.com


If you want to keep track of any kind of inventory, it is imperative that
you have a seperate record for each size.  That record should include a
column for the inventory count, what has been ordered and maybe the lead
time for ordering.  You can then group inventory records using parts
categories or inventory groups or what ever you want.  This is where the
normalization would help.

My humbel $.02 worth

-- 
Scott Hill

"May you solve interesting problems" - Author Unknown
"A fanatic is one who can't change his mind and won't change the subject." -
Sir Winston Churchill