Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to represent category, subcategory, product

Re: How to represent category, subcategory, product

From: Lennart <Erik.Lennart.Jonsson_at_gmail.com>
Date: 21 Nov 2006 13:09:40 -0800
Message-ID: <1164143379.764536.17230@j44g2000cwa.googlegroups.com> 






Neo wrote:


> > But this doesn't seem quite right because it allows the possibility that Prod.CatId != Prod.Subcat.CatId.

>

> T_Cat (CatID)

> T_Product (PrID)

> T_ProdCat (PrID, CatID)

>

> Derive subCats.




You've lost me here, how can you derive subcategory from PrID, CatID?



/Lennart
Received on Tue Nov 21 2006 - 15:09:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US