...
The quiz sections relationship is the key to associating questions with a quiz. The process flow is that the user first creates a quiz (record) and in the next step makes additional decisions which populate a section record. There is a minimum of a one-to-one relationship when a quiz is created, i.e., for every quiz created (quizzes w/o this association are not complete thus irrelevent) there is at least one section automatically associated with it. (As of 1/30/06, there are 72 'orphan' quizzes.)
Some quizzes have more than the one auto-generated section. The default name for auto-generated sections is 'Section 1' with the number increasing with each section. The same section relationship exists in Samigo with 'Default' as the auto-generated name, which will not be displayed unless it is changed.
# of Sections | # of Quizzes |
| # of Sections | # of Quizzes |
---|---|---|---|---|
1 | 916 |
| 6 | 14 |
2 | 186 |
| 7 | 12 |
3 | 59 |
| 8 | 5 |
4 | 27 |
| 10 | 2 |
5 | 21 |
| 11 | 1 |
No quizzes with 9 sectionsSome quizzes, based on the user's design, will have more than one section. The default name for auto-generated section is 'Section 1' with the number increasing with each section. This same default section relationship exists in Samigo with 'Default' as the auto-generated name. The name will not appear unless it is changed.
DATA ANALYSIS OF TABLE USAGE - QZ_SECTION_QUESTIONS & QZ_QUES_CATALOG
...