RE: Schema Design for Surveys

  • From: Katz.C@xxxxxxxxxxxx
  • To: niall.litchfield@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 10 Jan 2005 14:00:21 -0500

A survey on surveys!

My vote:
1 question table, 1 response table. The question table would be wider than
the response table since it would have the question text, as well as the
potential answer texts (the choices) and a flag that would tell the
application how to display the survey page - as a radio button page or a
check box page

The answer table has the question id and user id as the key and a fixed
number of columns - checked off corresponding to the user's selection

Why would anyone suggest multiple response tables?


-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
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: