SQL & PL/SQL

Hi All,

I want to make a small system managing our stocks in warehouse, but I don't know how to make a warehouse system, what table should I have?

I think I need to have at least:
. items
. inventory
...

and if one supplier sent some items to us, you know, the warehouse system is like a double record system, since stocks didn't get reased, it just moved from one place to another.

Any clue?

thanks.