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.
I have got 3 main problems:
- How to display each set of Q&A on PHP page based on customer profile?
- 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?
- 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?