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

 survey_no                      inherited from Survey
 question_no            inherited from Question
 response_no            identifier for the response
 response_text          the response itself
 user or survey occurrence no    (to indicate one set of survey results)

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)
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
Niall Litchfield
Oracle DBA

Other related posts: