database design

[yxez]

Hi friends,

I'm new to designing databases. We are developing a new Inventory System and I am task to help create the tables/entities associated with the system. Can you help give some links of sample tables about Inventory System pls. where i can prototype or pattern our
new system.

We are monitoring the lumber supplies in a Furniture Production Co.
And we have lots of lumber suppliers. We have a recieving storage area(in diff state) and production area(in another state).

I have identified the following tables:

1. supplier_table
2. lumber_table
3. inventory1(stocks received)
3. inventory2(stocks on hand)
4. inventory3(stocks delivered)

I want to know when im going out of lumber and order to the supplier.

Thanks a lot in advance

[shrikant_datex]

Hi
you should design database by making different modules and defining entities in that module and also defining coupling in the modules.
As a example you can consider

Inventory Module where you shall define your storage media its type, fertures, properties, classes etc.
Material Module where you shall define material types, properties, classes etc.
Supplier/Lumber module shall have address, contact information.
Rules Module where application user can define rules for storing inventory.etc..etc..

[yxez]

thanks