调查数据模型

本文介绍了调查数据模型的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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

我在想下列表格：

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

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

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:

Question - with a question type discriminator ifeld

PossibleAnswers- with a questionID and answer text field

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 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: