Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    1

    Unanswered: Database Design for Inventory System

    Hi All,

    Any one can suggest me how should i design my database for me to keep track all the equipment that i rent out and can display the totally inventory by location.

    Example:

    Initial
    Genset total unit = 3, location = JB warehouse.

    After rent out
    Genset total unit = 2, location = JB warehouse.
    Genset total unit = 1, location = SB warehouse.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    So you need to know what equipment you have, presumably classified by type (eg generator, accessories, other equipment). You also need to know ehere that equipme t is (which will probably be an intersection table to model one or more pieces of equipment will be at variuos locations.
    You will need to know what equipment is loaned out to whom. That infers you need a table for customerss, a tablr for loan contracts and another one of those intersection tables that indicates what equipment is loaned out to which customers under which loan contract....

    So do your basic analysis of tge project, scope out what you need to include in your model, what you dont need and decide on what you may need to support the organisation going forward.

    Take those requirements through the desin normalisation process.

    Refine the design in the light of test data, re iterate as required till you have a robust data model that supports the current requirements and probable futute requirements

    Understand what normalusation is, what it enforces and why it can refine designs to make them less vulnerable to changes in business requirements over time
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •