Questionnaires

The Questionnaires table (questionnaire_ext ) contains the basic definition (id, title, and description) for a survey. Surveys may contain one or more questions and may be administered any number of times to collect responses. A survey record provides a key for querying and obtaining a defined set of questions and/or their response values.

Questionnaire Question Assignments

The Questionnaire Question Assignments table ( quest_question_ext ) provides for a many-to-many association between a survey and the questions grouped within it.

A single question might pertain to multiple different requirements (e.g., a question definition may be unchanged from one NFPA revision to the next or a generic question might pertain equally well to requirements of multiple different regulations). Assuming individual questions can be shared across multiple surveys, each of these cases can be met by organizing one or more questions into a survey and associating that survey (or more than one survey) to the requirement record(s) they support.

Questions

The Questions table (question_ext) contains question definitions and relationships from one question to another when questions have conditional response sand cascading behavior.

Answer Options

The Answer Options table or (quest_answer_option_ext ) stores the available options for multiple-choice questions and their translation strings.

This table:

• takes advantage of the core to support localizable answer strings
• enables multiple answer selections per question without adding significantly complex application code
• provides simplicity for end users in defining answer options and managing translations of strings

Answers

The Answers table ( quest_answer_ext ) records the answers of any survey and enables applications to present responses directly for review as well as analyze, compute, summarize, and respond programmatically to results from one or multiple survey events.