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