Tweeted twitter.com/#!/StackDBAs/status/148227192013332480
2 Added 'database-design' tag; remove 'mysql' tag since there is nothing mysql-specific mentioned; improved format for readability
source | link

I am planning my database design to have 3 setsets of multiple questions for 3 typetypes of different customers, at (at least 3 at the moment), each set of them contains approx. 100 questions and waiting for their answers to be kept in the database. 

These questions are in a required questionnaire that is a very crucial material for my job, then posting them all as an email to myself is not an alternative. I am no expert here in this field,. I am not sure what is the best approach to store, retrieve, and manage them. 

Please take a look at my database design and advice for a better approach.

TABLE: QUESTIONS

  • SETID
  • Q1
  • Q2
  • Q3
  • ...

TABLE: QUESTIONNAIRE

  • CUSTOMERID
  • SETID
  • A1
  • A2
  • A3
  • ...

I have got 3 main problems:

  1. How to display each set of Q&A on PHP page based on customer profile?
  2. The questions need to be displayed on the web page, if by manually, text display, that would have been a time-consuming job for me if I decide to remove, edit, or delete some questions. What way would you recommend?
  3. All the questions (Q1,Q2, and ...) in QUESTIONS table need to map exactly as the answers (A1,A2,and...) in QUESTIONNAIRE table, is there any better approach?

I design to have 3 set of multiple questions for 3 type of different customers, at least 3 at the moment, each set of them contains approx. 100 questions and waiting for their answers to be kept in the database. These questions are in a required questionnaire that is a very crucial material for my job, then posting them all as an email to myself is not an alternative. I am no expert here in this field, not sure what is the best approach to store, retrieve, and manage them. Please take a look at my database design and advice for a better approach.

TABLE: QUESTIONS

  • SETID
  • Q1
  • Q2
  • Q3
  • ...

TABLE: QUESTIONNAIRE

  • CUSTOMERID
  • SETID
  • A1
  • A2
  • A3
  • ...

I have got 3 main problems:

  1. How to display each set of Q&A on PHP page based on customer profile?
  2. The questions need to be displayed on the web page, if by manually, text display, that would have been a time-consuming job for me if I decide to remove, edit, or delete some questions. What way would you recommend?
  3. All the questions (Q1,Q2, and ...) in QUESTIONS table need to map exactly as the answers (A1,A2,and...) in QUESTIONNAIRE table, is there any better approach?

I am planning my database design to have 3 sets of multiple questions for 3 types of different customers (at least 3 at the moment), each set of them contains approx. 100 questions and waiting for their answers to be kept in the database. 

These questions are in a required questionnaire that is a very crucial material for my job, then posting them all as an email to myself is not an alternative. I am no expert here in this field. I am not sure what is the best approach to store, retrieve, and manage them. 

Please take a look at my database design and advice for a better approach.

TABLE: QUESTIONS

  • SETID
  • Q1
  • Q2
  • Q3
  • ...

TABLE: QUESTIONNAIRE

  • CUSTOMERID
  • SETID
  • A1
  • A2
  • A3
  • ...

I have got 3 main problems:

  1. How to display each set of Q&A on PHP page based on customer profile?
  2. The questions need to be displayed on the web page, if by manually, text display, that would have been a time-consuming job for me if I decide to remove, edit, or delete some questions. What way would you recommend?
  3. All the questions (Q1,Q2, and ...) in QUESTIONS table need to map exactly as the answers (A1,A2,and...) in QUESTIONNAIRE table, is there any better approach?
1
source | link

How to keep long multiple of questions and answers in database?

I design to have 3 set of multiple questions for 3 type of different customers, at least 3 at the moment, each set of them contains approx. 100 questions and waiting for their answers to be kept in the database. These questions are in a required questionnaire that is a very crucial material for my job, then posting them all as an email to myself is not an alternative. I am no expert here in this field, not sure what is the best approach to store, retrieve, and manage them. Please take a look at my database design and advice for a better approach.

TABLE: QUESTIONS

  • SETID
  • Q1
  • Q2
  • Q3
  • ...

TABLE: QUESTIONNAIRE

  • CUSTOMERID
  • SETID
  • A1
  • A2
  • A3
  • ...

I have got 3 main problems:

  1. How to display each set of Q&A on PHP page based on customer profile?
  2. The questions need to be displayed on the web page, if by manually, text display, that would have been a time-consuming job for me if I decide to remove, edit, or delete some questions. What way would you recommend?
  3. All the questions (Q1,Q2, and ...) in QUESTIONS table need to map exactly as the answers (A1,A2,and...) in QUESTIONNAIRE table, is there any better approach?