how to relate tables and how normalized the database?Is is correct my work?

  • So in other words your class inheritance hierarchy is like this:

    Items

       Stockable

       Nonstockable

          FixedPrice

          VariablePrice

    Is that right?

  • What is a stockable item and what is a nonstockable item?  How about some concrete examples of what these items actually are?

  • yes my clas inheritance hierarchy is

    Items

             Stockable

              Nonstockable

              NondtockableTypes

              FixedPrice

              variableprice

    chargeableItems are of two types

    1)  Stockable

    2)  NonStockable

    StockableItem : (stockableId,cards,hardware)

    NonstockableItem: (itemCode,connection,services,promotion)

    futherMore Nonstockable items are of two types:

    FixedPrice:  where price of each item is known and enterd in the table anainst the item.

    VariablePrice: for which the price is input when the item is included in the invoice.

  • OK that narrows it down a bit, since StockableItems and NonstockableItems are completely different things (i.e., Products and Services), I don't have a problem storing them in separate tables as suggested by other posters.

    The next question is what are *all* of the differences between FixedPrice items and VariablePrice items?  Is FixedPrice/VariablePrice just an attribute of the NonstockableItems or is it a completely different class of item?

  • NonStockable Item have two categorys such as

    1) Category Connection is fixPrice

    2) Category Services is Variable Price

    FixPrice : (connectionCharges,packagePlan,SIMCustomDuty)

    VariablePrice: (CEDonLineRent,repairCharges,rentalCharges,SIMreplacementCharges,

    depreciationCharges)

  • NonStockable Item have two categorys such as

    1) Category Connection is fixPrice

    2) Category Services is Variable Price

    FixPrice : (connectionCharges,packagePlan,SIMCustomDuty)

    VariablePrice: (CEDonLineRent,repairCharges,rentalCharges,SIMreplacementCharges,

    depreciationCharges)

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply