Re: Implementing product attributes

Joe \"Nuke Me Xemu\" Foster wrote:
>
> "Fernando" <spamers_at_must.die> wrote in message news:s8u6dsgnvpgrf3q4imhpnhdlirlrs248iv@4ax.com...
>
> > Hi!
 

> > I have a datbase with n products. Each of these products
> > belongs to 1 and only one cathegory.
 

> I don't know if this is always the *best* way, but many projects have
> used sub-tables to model this. It mirrors an object hierarchy, sort of.
> Say we have an Product table, with Book and Beverage sub-tables. Each
> product has a Description, say, while books and beverages each have
> attributes unique to books and beverages.
>
> Product
> ID Description
> -- -----------
> 1 The Satanic Verses
> 2 ToothRot Cola
> 3 Tommyknockers, The
>
> Book
> ProductID ISBN Author
> --------- ---- ------
> 1 666 Rushdie, Salman
> 3 667 King, Stephen
>
> Beverage
> ProductID Liters Manufacturer
> --------- ------ ------------
> 2 2.0 American Denture Association
>
 

> Either scheme gets unwieldy fast. I'd love to hear about alternatives!

Why would the first scheme get unweildy fast?

Kyle Lahnakoski                                  Arcavia Software Ltd.
(416) 892-7784                                 http://www.arcavia.com