我正在为一个ASP应用程序开发一个简单的调查模块,我想获得一些关于数据模型的建议。
问题可以是三种类型之一:多重选择,多重答案;多重选择,单一回答和自由回应。
我在想下列表格:
我这样做太简单了吗?
解决方案查看
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:
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:
更多推荐
调查数据模型
发布评论