Re: Dynamic surveys
Posted by: Bob Field
Date: November 03, 2006 01:32PM

It makes most sense to generalize how the questions and answers are stored. When you have to create new tables to create a new survey, this isn't really dynamic. What makes sense is to create a table structure allowing for a dynamic number of questions and answers, and to specify which survey they belong to, then creating a survey does not involve changing the design of the database. So this means avoiding storing questions/answers as columns but rather as rows in a separate table. So you'd have your main questionaire table with a row per survey, then a table of questions, a table of respondents, and finally a table of answers.

Options: ReplyQuote


Subject
Written By
Posted
November 03, 2006 10:01AM
Re: Dynamic surveys
November 03, 2006 01:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.