Re: How to represent a Specification in the Relational model

From: S. Robert James <srobertjames_at_gmail.com>
Date: 9 Jan 2007 22:37:54 -0800
Message-ID: <1168411074.330443.211860@i39g2000hsf.googlegroups.com>

Neo wrote:
> > what's the solution to problem #1? An order can be specified either for
> > a product (Toaster), without specifying a particular subproduct (any
> > Toaster); or an order can be specified for a particular subproduct (GE
> > Toaster 3000). How are both of those orders modelled?
>
> Would the following work?
>
> T_Cat
> 100 Toaster
> 200 Roaster
>
> T_Product
> 1 Generic Toaster
> 2 GE Toaster 3000

Interesting idea. But "no subproduct specified" isn't exactly the same thing as "Generic". For instance, retrieve all of the orders without any subproduct specified. Received on Wed Jan 10 2007 - 00:37:54 CST