Home » RDBMS Server » Server Administration » Dynamic structure of a table?!!
Dynamic structure of a table?!! [message #149386] Thu, 01 December 2005 07:42 Go to next message
Achchan
Messages: 86
Registered: June 2005
Member
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

Report message to a moderator

Re: Dynamic structure of a table?!! [message #149573 is a reply to message #149386] Fri, 02 December 2005 05:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
so will your code also change dynamically?

Report message to a moderator

Re: Dynamic structure of a table?!! [message #149713 is a reply to message #149386] Sat, 03 December 2005 04:07 Go to previous message
Achchan
Messages: 86
Registered: June 2005
Member
Yes! It may seems strange but there is a resident team for performing these changes in application level.Don't ask me why,I do not know too Wink
-Thanks

Report message to a moderator

Previous Topic: database creation(dbca is not working in winxp)
Next Topic: Able to login as sysdba without the privilege being granted
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 26 18:13:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.