Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The quiz sections relationship is the key to associating questions with a quiz. The process flow is that the user first creates a quiz (record) and in the next step makes additional decisions which populate a section record. There is a minimum of a one-to-one relationship when a quiz is created, i.e., for every quiz created (quizzes w/o this association are not complete thus irrelevent) there is at least one section automatically associated with it. Some quizzes, based on the user's design, will have more than one section.

The qz_ques_catalog table is contains all questions. Each unique questionid has a question type and owner. All relationships to answers and feedback are associated with the primary key, quesionid.

The association of quizzes with questions occurs in qz_section_questions. The unique secid (from qz_section) is matched with a question key (qcid) - the two foreign keys are the primary key with additional information for the order/sequence of appearance.