Database design based on a questionnaire

[brother]

Hi guys,

I'm currently in the process of making a database that will store data from a questionnaire we are handing out at work. This questionnaire is quite comprehensive and has a lot of questions, which means that I will exeed the maximum allowed number of fields in a table (255). So, now im wondering how to design my tables and their realtionships to get this thing working. The questionnaire is divided into 8 sections, and it consists of both text and number input.

My thoughts on setting this up is as follows:

TblEmployee has a one-to-many relationship to TblSection1.
TblSection1 has a one-to-one relationship to TblSection2.
TblSection2 has a one -to-one relationship with TblSection3 etc.

Does it look like I'm on the right track here, or is there some other way to do it? All comments to help me on my way is greatly appreciated!!


Thanks

 

[JamesMcS]

Rather than having question numbers as field names, why not just have a table with Section Number, Question Number, QuestionID and Question Text or something in it? Then it can be as big as you like.

Have another table for answers with EmpID, QuestionID and answer in it. Then when it comes to reporting you only have to link 3 tables up in a query (Employees, Questions, Answers) and you can do whatever you like with it.

Did you post a similar question to this a couple of weeks ago? Bells are ringing....

 

[brother]

Hi James,

I found the similar post, I should have done better research before asking.

I'll take a look at this approach once I get back to work, and post my comments.


Thanks alot

 

[JamesMcS]

Hey no worries - frankly I'm amazed I remembered it!

Speak to you soon!

J