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