DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: database design

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    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

  2. #2
    Join Date
    Jul 2005
    Location
    PUNE-INDIA
    Posts
    12

    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..
    Regards
    Shrikant Pune
    shrikant23_datex@hotmail.com

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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
  •  


Click Here to Expand Forum to Full Width