• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Ingredients

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint