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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2008-09-04 : 04:54:10
|
| Has any one any ideas how I should design the tables for a questionaire ? Somes questions answers will be Y/N, others Y/N with additional text and some just text. This will be a web app (asp.net) I thougth along thelines of a User table, a question table and an answer table - it the answer tbale that is baffling me a bit as to how to design it. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 05:00:29
|
| user(userid int,... other attributes)question(questionid int identity(1,1),question varchar(1000),...any other fields)answer(answerid int identity,userid fk to user,questionid fk to question,answer varchar(8000)) |
 |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-09-04 : 05:04:52
|
| slight modification in Answer tableanswer(answerid int identity,userid fk to user,questionid fk to question,answer Char(1), Remarks varchar(8000)) |
|
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2008-09-04 : 05:47:11
|
| Thanks both. Great help. |
|
|
|
|
|
|
Questionaire