Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
juancruzhurtado
Starting Member
3 Posts |
 Posted - 2010-05-21 : 02:37:56
|
| Hello everybody!I am starting to work on a web page for a medical firm.This webpage will include about ten different questionnaires for Patients.The longest questionnaire has 160 questions, most of them having a yes/no answer.I am not sure what the best way to go about this is.The questionnaires are not likely to change.So, should I a table for each questionnaire?Or should I have a three tables: questionnaires, questions, and answers?The latter is probably better for scalability, but the other on might be better to make data decisions with.I am not sure if this was clear enough. Hopefully it was.I appreciate any answers, tips, comments.Juan |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-05-21 : 04:28:24
|
"The requirement is not likely to change." The 2nd most common lie in history after "I'll ring you in the morning"  I'd go with the 3rd option. |
 |
|
|
dportas
Yak Posting Veteran
53 Posts |
Posted - 2010-05-21 : 10:28:30
|
| None of the above. Create a data model for *patients* and the information you are collecting about patients. The questionnaire is just a method used to gather the data. It doesn't have much to do with the database design. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-21 : 10:30:33
|
| Data is more difficult to query from Questionnaires-Questions-Answers, BUT you could always "warehouse" the data, once it has been entered, to make it easier to query.We have additional tables for our Surveys - LookupValues - for questions that have a SELECT list answerQuestionnaires-Questions-Answers can be used to build any number of additional Questionnaires, in the future. |
|
|
|
|
|
|
|
|
Very long questionnaires, unlikely to change