...
A top down review of the existing tables and data shows the following hierarchical structure for quizzes in the MyUCDavis cms. The hierarchy of Quiz Builder revolves around quizzes, quiz sections, questions, answers, and finally student response data associated with quiz attempts. In addition, the original design suggests a grouping mechanism for quizzes in a categories table, but these tables are so little used as to be negligible.
DATA ANALYSIS OF TABLE USAGE
The key table here is qz_quiz which contains the primary key identifying the quiz (quizID), the quiz name, the kerberos_name of the owner, and quiz type information.
The two category tables on the left side of the graphic allow the user to create a category and then to associate quizzes with that category. This feature is virtually unused (the majority of the records were created by IET personnel as test data.) This feature does not need to be ported to sakai.