I'm trying to design a database that will support a dynamic questionnaire applications. What I mean is the questions most likely will change from time to time.
I want a database that will have a table to store the questions with expected results and the ability to pull the current question in the table and use them for a questionnaire. The questions and sub-questions are categorized using the following structure: Family, Control, Metric
For each questionnaire, I need to store the name, address, date etc and the answers to each question so that it can be retrieved.
Unfortunately, I need help..
Here is what I have so far. Can someone help me construct this into a meaningful solution?