...
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.
RELATIONSHIPS BETWEEN QUESTIONS AND COLLECTIONS
(Note: Graphic data valid on 8/14/06)
Collections is an optional feature of Quiz Builder which allows faculty and staff to organize their large generic pool of questions into subpools of optionally sequenced questions.
Breakdown as of 8/14/06:
- Total noumber of collections: 319
- Total number of collection owners: 74
- Number of valid owners: 60
- Number of collections owned by valid users: 206
- Number of valid collections containing questions: 197
- Number of distinct questions contained in valid collections: 1777