MySQL Forums
Forum List  »  Newbie

Re: Questionnaire builder (DB structure) ...am i close?
Posted by: thedohman
Date: June 14, 2005 10:20AM

Did a project similar to this a couple years ago for school, using ASP and MSSQL...

I would use one field for all answer types... no reason to keep them seperate, as the interpretation of that answer is in the UI, and the type of answer is beinig stored... it should make the queries a little easier for you...

There needs to be a question table, too, I think you know that, you just didn't list it.

Your answer table might want a reference to the template table also, so the same question could be used for different questionaires, and the results kept seperate.

And I haven't done much DB stuff since this project a couple years ago, so I'm a newbie too. Someone else may have more to say, but I like it so far. Good job.

Options: ReplyQuote


Subject
Written By
Posted
Re: Questionnaire builder (DB structure) ...am i close?
June 14, 2005 10:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.