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

Question

Post reply

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

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

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

tnk SSCrazy Points: 2613 More actions · Answer 1

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

Items

Stockable

Nonstockable

FixedPrice

VariablePrice

Is that right?

Mike C SSC-Insane Points: 23224 More actions · Answer 2

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

naila-330342 Right there with Babe Points: 798 More actions · Answer 3

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.

Mike C SSC-Insane Points: 23224 More actions · Answer 4

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?

naila-330342 Right there with Babe Points: 798 More actions · Answer 5

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)

naila-330342 Right there with Babe Points: 798 More actions · Answer 6