...
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 | |
---|---|---|
mchoice | 6928 | multiple choice |
paragraph | 1462 | free response |
fillinuo | 540 | fill in, unordered |
fillino | 209 | fill in, ordered |
matching | 208 | |
calculated | 188 |
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.