Re: How to represent category, subcategory, product

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Tue, 21 Nov 2006 21:58:33 GMT
Message-ID: <dEK8h.23133$cz.352131_at_ursa-nb00s0.nbnet.nb.ca>


TH wrote:

> I don't know if this counts as database theory or not so feel free to
> tell me this is an inappropriate group for this post but anyway: can
> anyone please offer any advice as to what would be the right pattern
> (is pattern the right word?) to model the following scenario in a
> relational database?

Design requires tradeoffs to balance the needs of all your requirements. I assume the vast majority of your requirements are missing from the very simple problem statement you gave.

To design well, one must be able to devise any number of designs and evaluate the consequences of different designs. Received on Tue Nov 21 2006 - 22:58:33 CET

Original text of this message