Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dynamic structure of a table?!!

Dynamic structure of a table?!!

From: Ach C via DBMonster.com <u11311_at_uwe>
Date: Thu, 01 Dec 2005 13:41:39 GMT
Message-ID: <582f72681168d@uwe>


Hi all,
 I have an ER diagram which has an entity called "Form" .This is a typical electronic Form but number of its fields are not known and may vary at future.

 What is the best logical design for this case? If I create a table for this Form I should add columns to it in the future.This does not seem nice.Also I do not want to use "Entity-Attribute-Value" method as described at:

 http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

-Thanks

--

Message posted via http://www.dbmonster.com Received on Thu Dec 01 2005 - 07:41:39 CST

Original text of this message

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