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: Attribute-values in separate table

Re: Attribute-values in separate table

From: <anjasmedts_at_hotmail.com>
Date: Fri, 31 Aug 2007 02:15:01 -0700
Message-ID: <1188551701.232978.17290@r23g2000prd.googlegroups.com>


> Why not just have a "HasLock" relation with the id's of the furniture
> with locks? And a "HasWheels" relation with the id's of the furniture
> with wheels?- Tekst uit oorspronkelijk bericht niet weergeven -

Your solution creates a lot of similar tables, whereas mine groups all those tables into one.
Creation of new attributes on the fly is done adding a record in my solution and creating a new table in yours. So my opinion is that my solution is preferable.

But I'm open to all remarks!

Anja. Received on Fri Aug 31 2007 - 04:15:01 CDT

Original text of this message

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