MYUCDAVIS QUIZ BUILDER ARCHITECTURE SUMMARY
The purpose of this document is to identify the architecture of MyUCDavis Quiz Builder on the basis of database tables and table relationships. The intent is to use this documentation in support of migrating quiz content from MyUCDavis to the Davis implementation of Sakai.
RELATIONSHIP BETWEEN A QUIZ AND A COURSE
...
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
