Basically I will be creating a site where users will be required to register and then fill out a LONG survey. I have never designed a database from scratch, and was wondering if anyone could point me in the right direction. What would be the easiest way to store the questions, help for the questions, and the user input?
As of right now I am thinking of the following:
A table (users) with like userid, email, name, last name, etc...
A table (questions) with all the questions
A table (ques_help) which would have all the descriptions for each of the questions
A table (user_survey) which would record all the answers to the questions.
All the tables would be linked via userid.
Does this seem efficient? Any help is appreciated!!