Design ideas for a system handling form data
Hello all, I am working on designing a system that basicly handles forms and I'm trying to come up with some new ideas.
Lets say the system has a bunch of forms to choose from. A regular user will go in, choose a form, fill it out and submit it. Administrators can go in an change the questions on the form, the options available on multiple choice questions, etc. I'm stuck on how the system should save all the answers that the user enters into the form.
We have a system in place that saves the answers in a table/column specified by the question. Therefore every time a new question gets added to a form a database administrator such as myself will have to ensure that there is a place in the database to save it. I want to get away from that.
I was just reading an article on Entity-Attribute-Value Modeling which uses one big table to store all the answers. That may be a good solution for this system. Does anyone have any suggestions or experiences to share?