-
database design
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
-
Database Design
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..
-
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|