调查数据模型 [英] Survey Data Model

问题描述

我正在为一个ASP应用程序开发一个简单的调查模块，我想获得一些关于数据模型的建议。

问题可以是三种类型之一：多重选择，多重答案;多重选择，单一回答和自由回应。

我在想下列表格：

1. 问题 - 带有问题类型鉴别符ifeld


2. PossibleAnswers-包含问题ID和答案文本字段


3. SurveyQuestionResponse- ，clientID和答案文本

我这样做太简单了吗？

解决方案

查看

   

I'm developing a simple survey module for an ASP application I'm working on and I'd like to get some suggestions on the data model.

Questions can be one of three types - multiple choice, multiple answer; multiple choice, single answer, and free response.

I'm thinking of the following tables:

1. Question - with a question type discriminator ifeld
2. PossibleAnswers- with a questionID and answer text field
3. SurveyQuestionResponse- with a questionID, a clientID, and answer text

Am I making this too simple?

解决方案

Take a look at the
    Data Model library at databaseanswers.org
Models #76 thru #81 seem pertinent, if only for "inspiration".

A lot depends on the level of sophistication of the surveys you manage, as some surveys in particular dynamic ones (aimed at removing some of the bias) require additional fields for storing properties such as the probabilities with which a particular question (or reply) is used, the many forms of a question and associated probability, and also the recording of the questions and suggested replies that were effectively offered for a give surveyee.

The model the above link:

这篇关于调查数据模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！