Database modeling in MySQL

Question

1.00/5 (1 vote)

See more:

Hi all,

I have a questionnaire with 70-80 fields to record. I just want to put it into a database. I wonder that I should create a single table with 70-80 columns and break it down. Or else I can record it page wise. Is there any drawback on that, your feedback warmly welcome.

Thanks

Posted 21-Aug-13 7:39am

CodingLover

Add a Solution

Comments

Jörgen Andersson 21-Aug-13 13:54pm

Are you using all the fields equally much?
You can earn some queryspeed if you're using just some of the fields a lot and split them into a separate table that would fit in the memory cache.
Otherwise I wouldn't care

CodingLover 22-Aug-13 2:15am

Actually all the fields are in different pages. Per page like 10-15 fields to track. So I can split them into different tables.

Sergey Alexandrovich Kryukov 21-Aug-13 14:26pm

It depends on a number of factors. This is not a sound question...
—SA

CodingLover 22-Aug-13 2:15am

Could be, but for me something is there :) Thanks for the response.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jörgen Andersson · Accepted Answer · 2013-08-21T20:52:00

Now I understood your question.

It depends on what kind of questionnaire it is. Text answers or a checkboxes.

If it's checkboxes I'd make a response table having two columns. RespondentID and ChoiceID where every response makes a new line in the table.
With corresponding tables for Respondents, questions and choices.

If it's text answers you'll need three columns: RespondentID, QuestionID and Answer.
Also here you'll need corresponding Respondent and question tables.

If you're just storing the answers in the database you don't need to bother about pages, but if it's a web questionnaire you'll need to store a lot of layout data aswell.