Re: Help! Difficulty understanding DB -> Object mapping

> I see your point here, but orders may be volatile - you may want to
> change a description or some other data per customer per order -
maybe a
> customized version of a product.

Yes, if you are producing customized products, this is probably a good
design.

> Also, if you basically move everything to ProductVersion, you might
as
> well consolidate the versions into one table, no?
> PRODUCT: Product_ID, Product_Version, Title, Price
> ORDER_ITEM: Order_ID, Product_ID, Product_Version

I would still have a product table with only Product_ID as primary key.
There might be information for which you don't need to track history
changes. And a customer selects a product, he/she selects a Product_ID.
The customer can not select version. He/she will always get the latest
version.

Fredrik Bertilsson
http://butler.sourceforge.net

.

Relevant Pages

  • Re: defining quality of OOA and OOD models
    ... must be done) while an OOA model describes the solution (How it should ... Using the term "analysis" to mean "design" should, if nothing else, not ... bridge the chasm between customer problem spaces and the computing ... the problem space abstraction that dominates OOA is ...
    (comp.object)
  • VUI Designer Position available with eLoyalty
    ... eLoyalty Corporation is a leading management consulting, ... eLoyalty's broad range of enterprise Customer ... This creative and detail-oriented individual will design and consult on ... conversational speech applications, working to achieve exceptional ...
    (comp.speech.research)
  • Re: Organizing My Boss
    ... > shop foreman, etc.) to make sure that you understand what their needs are. ... >> moment we receive an RFQ, to the moment a job is shipped to the customer. ... Somehow, accounting finds out that we got a new job in, and finds the ... The design is briefly reviewed by my boss and the shop ...
    (comp.cad.solidworks)
  • Re: Organizing My Boss
    ... to the moment a job is shipped to the customer. ... Somehow, accounting finds out that we got a new job in, and finds the ... The design is briefly reviewed by my boss and the shop ...
    (comp.cad.solidworks)
  • OT: Organizing My Boss
    ... My boss is one of the most un-organized persons I know. ... to the moment a job is shipped to the customer. ... The design is briefly reviewed by my boss and the shop ... The shop then gets their hands on the job for manufacture. ...
    (comp.cad.solidworks)