...
No quizzes with 9 sections
DATA ANALYSIS OF TABLE USAGE - QZ_
...
QUES_
...
CATALOG & QZ_
...
SECTION_
...
QUESTIONS
The qz_ques_catalog table contains all questions. Questionid is the primary key, with question name, question type, and kerberos_name as required fields. All relationships to answers and feedback are associated with this primary key, questionID.
(As of 1/30/06, there was a total of 313 unique question owners and 72 of these had more than 25 questions in their pool.)
There are 6 question types possible in this pool, with the following distribution on a count of x total as of 1/30/06:
Q TYPE | COUNT |
---|---|
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.