Re: Table Design Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 13 Mar 2000 19:45:44 +0100
Message-ID: <952979872.28946.0.pluto.d4ee154e@news.demon.nl>

productid
product_description
parent_productid
root_productid -- denormalized to allow for the connect by not available in joins, the 'root' of the product tree.
Abstracted from a live example.

Hth,

Sybrand Bakker, Oracle DBA

Sean <dolans_at_my-deja.com> wrote in message news:8ajba7$5ic$1_at_nnrp1.deja.com...
> I am curious of the best way to approach this design. If you had
> products and then subproducts and then further subproducts, how would
> you lay out the table? Multiple? Or one table with a "Parent" product
> entry? For example : Printers:HP:4Si:Toner
>
> Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Mar 13 2000 - 12:45:44 CST