Re: How to represent a Specification in the Relational model

> 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
1 Generic Toaster
2 GE Toaster 3000

T_ProdCat

1      100
2      100
2      200

T_Order
10 Order10
20 Order20

T_OrderProduct
10 1
20 2 Received on Wed Jan 10 2007 - 00:08:01 CST