I agree with Imar.

I would argue that the price is dependent on the Order - rather than the part number. From the POV of the order price- the price depends on the order itself. As a second order at another time could have another price.

I guess this could also be done by normalizing out the prices and create a pricing table that is effective dated and related to the part.

The second way is probably "more proper".. but I think you can over-normalize things aso. And based on the requirements for the system, there might not be value in normalizing out the pricing.

At least, that's my opinion.



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee