调查数据模型
我正在为我正在开发的 ASP 应用程序开发一个简单的调查模块，我想获得一些有关数据模型的建议。
问题可以是三种类型之一——多项选择、多项回答；多项选择、单选、自由回答。
我正在考虑以下表格：
- 问题 - 带有问题类型鉴别器 ifeldpossibleAnswers-
- 带有问题 ID 和答案文本字段
- SurveyQuestionResponse- 带有问题 ID、客户端 ID 和答案文本
我是否让这个太简单了？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看看
databaseanswers.org 上的数据模型库
模型 #76 到 #81 似乎很相关，即使只是为了“灵感”。
很大程度上取决于您管理的调查的复杂程度，因为某些调查，特别是动态调查（旨在消除一些偏见）需要额外的字段来存储属性，例如特定问题（或答复）出现的概率使用的问题的多种形式和相关的概率，以及问题的记录和为给定调查对象有效提供的建议答复。
上述链接的模型：
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: