Re: How to represent a Specification in the Relational model

From: Neo <neo55592_at_hotmail.com>
Date: 10 Jan 2007 07:40:34 -0800
Message-ID: <1168443630.600294.109280_at_k58g2000hse.googlegroups.com>


> > T_Cat
> > 100 Toaster
> > 200 Roaster
> >
> > T_Product
> > 1 Generic Toaster
> > 2 GE Toaster 3000
> >
> > T_ProdCat
> > 1 100
> > 2 100
> > 2 200
>
> 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.

This recent thread titled "How to represent category, subcategory, product" may be helpful:
http://groups.google.com/group/comp.databases.theory/browse_frm/thread/884a0a00ae42a0f5/# Received on Wed Jan 10 2007 - 16:40:34 CET

Original text of this message