I need to build a survey system allowing my clients to create and post their surveys for their own customers and prospects. The system must be developed using ASP pages with VB Script to fit existing infrastructure. Database design has already been completed, can start with Access but eventually will be MS SQL Server.
Clients have to be able:
- create surveys with multiple types of questions
- save draft of surveys
- use existing surveys as templates
- preview and move questions around
- post survey to their customers via e-mail link or a link on existing page
- branch between questions
Client's customers have to be able:
- to fill outs surveys
- save unfinished surveys
- Clients should be able to track filled surveys and analyze results
I attached a more detailed functional requirement
And here is a most of the DB needed. This is an extract from a larger system. Please use it even though it may look poorly designed and excessive in number of columns. Only a few of them are truly needed for the surveys part. There is no 'Invitation' part yet.
Sorry - this site really does not like file names with spaces... Here is the renamed version.