My plan is to build a CI survey application. The basic requirements are:
- The admin user must be able to create a survey, using various types of questions (based on templates).
- He must also be able to edit or delete a survey.
- When the survey is completed, other users must be invited to fill in the survey.
- In the end, the admin user must be able to generate a report with the results.
Of course, there's a lot more to it than that, but that's the general picture.
My biggest question is: how does the data model look like for an application like this? Which tables and fields, and which relationships between tables?
And how do I cope with questions that can have multiple answers (like in a set of checkboxes)?
I want to make a good plan for this before I start. And not get stranded half way.
Maybe there are good examples available that I can learn from?
Any help is appreciated.