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

    Database design issue

    Hello,
    I have an Inventory DB. the DB mainly manages the equipments, different kinds of them, some has a serial number and some don't (like small connectors).
    I have a table that contain all these equipments. When the equipments with no serial number are added, they usually contain a quantity number like 200 RJ45 ethernet connectors. When they are ordered out of the warehouse, probably 56 RJ45 connectors are ordered. the orderdetails table contain only the equipment ID of the equipment. So, I will not be able to select the same equipement item again, but I have used only quarter the equipment quantity.

    What can I do to redesign these tables (equipment, orders, orderdetails)

    Thanks

    MTI

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    I'd just maintain a running total of the "commodity" products. If you want to use identical code for all types of products, then you can keep a running total of the serial number products as well, and this total will always be either one or zero.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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