RE: Schema Design for Surveys
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 Jan 2005 13:15:02 -0500
why not a shallow table:
Survey and Question could be setup as one or probably two tables then
ques_responses
survey_no inherited from Survey
question_no inherited from Question
response_no identifier for the response
response_text the response itself
user_responses
user or survey occurrence no (to indicate one set of survey results)
survey_no,
question_no,
response_no
Obviously the board does not know all the details and required features but
this came to mind and perhaps it will give you something to think about.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Niall Litchfield
Sent: Monday, January 10, 2005 12:41 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Schema Design for Surveys
We have a requirement for a system that will record answers to more
than one survey. Each survey will consist of a number of questions
with responses that can be
multiple choice (eg pick up to 3 preferences from 8)
text
numeric - single answer
How would people go
one question table, one wide response table
one question table, multiple response tables varying on type of response
some other construct.
This is an internal discussion that we are having here that interests
me (and I do have a preference) and I'd be interested to see what folk
think.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
