| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: How to represent category, subcategory, product
> Agreed, but how do you map this to the relations category, subcategory and product?
T_Cat
1 Device
2 Computer
3 Printer
T_Prod
1 DellPc1
2 HpPr1
T_ProdCat
PROD CAT
DellPc1 Device
DellPc1 Computer
HpPr1 Device
HpPr1 Printer
Based on above data, we can derive Computer and Printer are currently
subCats of Device,
because:
Device = {DellPc1, HpPr1}
Computer = {DellPc1}
Printer = {HpPr1}
Computer and Printer are proper subcategories of Device. Received on Tue Nov 21 2006 - 15:55:21 CST
 |
 |