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
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).
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..