10 Application Pages: 3 User Pages Survey Survey Completed Survey Offline
7 Administration Pages Create Survey Add Survey Questions Survey Manager Edit Survey Edit Survey Questions Launch Survey Survey Statistics
1 Data Source: 1 Database with: 4 Tables Surveys Includes records for all surveys, such as fields for the ID, the survey name, the start date, the end date, the survey completed message, and the current status (whether the survey is live or not) SurveyQuestions Stores all the questions and possible responses for surveys with fields for the ID, the affiliated survey, the question type, the question, and the responses SurveyResults Keeps track of the survey results by maintaining fields for the ID, the associated survey and question, and the response chosen QuestionTypes Lists and describes the types of questions available, such as multiple choice (radio buttons) and discussion (text area)
3 Views SurveyLaunchStats A virtual table joining the Surveys and SurveyQuestions tables SurveyStatistics A virtual table joining the Surveys, SurveyQuestions, and SurveyResults tables SurveyManagerQry A virtual table that extracts distinct results from the Surveys table
2 Stored Procedures RemoveOrphanQuestions A SQL procedure that deletes questions that no longer have a connected survey; used when deleting surveys RemoveOrphanResponses A SQL procedure that deletes responses that no longer have a connected question; used when deleting surveys or questions
|