Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Question Inventory tracking design Issue

    Hi All,

    I am working on a small project with some peculiar issues.

    I have to track SUPPLIERS, SHIPMENTS, PRODUCTS, AND SALE. Now these are the major entities.

    The problems is this:
    There is a concept ITEM which is required as product seems to be just a category (Name, type, properties). As I need to track each individual ITEM not just reduced quantity in stock for a PRODUCT sold. As an ITEM might be returned defective, therefore requiring them to be tracked seperatly.

    Now these are the relationships and cardinalities:

    SUPPLIER ---sends--- SHIPMENT (1:N )

    SHIPMENT----contains-----ITEM (N:M)

    ITEM -----make-----PRODUCT (M:N) ** has we can combine same items to form different products. eg. Item01 - biscuits can be packaged with item03 coffee. Or they can be sold seperately as products individually.

    THE ISSUE: HOW DOES SALE fit in ? Items are sold or PRODUCTS are sold. Items are put on offer (like auction listing for example) OR PRODUCTS are listed ?.

    I hope I made the situtation clear.

    Any help would be appreciated.

    Regards

    Sunny

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    It is true that some kinds of product are tracked individually (like PCs, TVs, cars - they have serial numbers to identify them), and some are not (like biscuits, coffee, spanners, newspapers, ...) You'd have to treat the former differently from the latter.

    However, your post seems to imply that you intend to track individual packets of biscuits or jars of coffee! Nobody does that surely!?

    Anyway, for items that are tracked individually, I imagine you would start off with an order that related to a product, not to a specific item: "customer X has ordered 1 of product Y". Then at some point in the process (maybe days or weeks later) you will assign as specific item to the order: "item Z assigned to order O".

    I don't know if that helps at all.

  3. #3
    Join Date
    Mar 2006
    Posts
    2

    Talking

    Dear andrewst,

    thanks.

    I know Bad example. Not coffee or biscuits. Let imagine items like cameras and memory sticks. Now I can sell them together as a COMBO product or individually as products themselves.

    So for instance in one Product I can have One item camera and X2 items memory sticks.


    ALSO- you asked if there was a item code- yes only BAR CODES. I hope this is what your were asking

    The issue was do I have relationship:

    OPTION A: PRODUCT ------sold on----- ORDER (M:N)

    OPTION B: ITEM -------sold on-------ORDER (M:N)

    I hope it is clearer

    thanks
    Last edited by sachsing; 03-22-06 at 19:08.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Oh, I see. How about selling only Products, but some Products consist of only a single item?

Posting Permissions

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