Re: How to represent a Specification in the Relational model
From: Neo <neo55592_at_hotmail.com>
Date: 9 Jan 2007 22:08:01 -0800
Message-ID: <1168409281.404379.148920_at_o58g2000hsb.googlegroups.com>
Date: 9 Jan 2007 22:08:01 -0800
Message-ID: <1168409281.404379.148920_at_o58g2000hsb.googlegroups.com>
> 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
T_ProdCat
T_Order
1 Generic Toaster
2 GE Toaster 3000
1 100
2 100
2 200
10 Order10
20 Order20
T_OrderProduct
10 1
20 2
Received on Wed Jan 10 2007 - 07:08:01 CET