Difference between revisions of "Math4Team/RIT/Projects"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
(I've already renamed Clinic and Provider to School and Teacher.) | (I've already renamed Clinic and Provider to School and Teacher.) | ||
[[Image:QuestionERDiagram.PNG]] | [[Image:QuestionERDiagram.PNG]] | ||
| − | ==== | + | ====Table Dictionary==== |
{{Definition_table | {{Definition_table | ||
|Questionnaire |A collection of questions that might be used in a Survey, Quiz, Exam, etc. | |Questionnaire |A collection of questions that might be used in a Survey, Quiz, Exam, etc. | ||
| Line 16: | Line 16: | ||
|School | An organization | |School | An organization | ||
|Person | An individual, such as a Teacher, Student, etc. | |Person | An individual, such as a Teacher, Student, etc. | ||
| + | }} | ||
| + | ====Questionnaire Field Dictionary==== | ||
| + | {{Definition_table | ||
| + | |ID | primary key | ||
| + | |Questionnaire | Title of questionnaire | ||
| + | |Category | Classifier ID | ||
| + | |Notes | Description, Image link, rich format data | ||
| + | |StartDate | Effective date for this instance | ||
| + | |EndDate | Expiry date of this instance | ||
| + | }} | ||
| + | ====Question Field Dictionary==== | ||
| + | {{Definition_table | ||
| + | |ID | primary key | ||
| + | |Questionnaire | ID of parent questionnaire | ||
| + | |Sequence | number to order question among questions on questionnaire | ||
| + | |Question | text problem statement | ||
| + | |AnswerType | ID of the suitable answer type | ||
| + | |Jump | conditional number to redirect survey question sequence | ||
| + | |Notes | Description, images, rich format data | ||
| + | |StartDate | Effective date of this question instance | ||
| + | |EndDate | Expiry date of this instance | ||
}} | }} | ||
Revision as of 12:03, 3 April 2009
Question Support API
http://git.sugarlabs.org/projects/question-support-api
Data Model
A possible data model I built for a corporate medical department's medical records:
(I've already renamed Clinic and Provider to School and Teacher.)
Table Dictionary
| Questionnaire | A collection of questions that might be used in a Survey, Quiz, Exam, etc. | |
| Question | A problem seeking an answer | |
| Answer | A potential solution to the problem | |
| AnswerType | The class of answer suitable for the problem or question | |
| Survey | An event instance of collecting Answers to Questions or problems | |
| Response | An event instance of the Student providing an answer to a question on a Survey or Quiz, etc | |
| School | An organization | |
| Person | An individual, such as a Teacher, Student, etc. |
Questionnaire Field Dictionary
| ID | primary key | |
| Questionnaire | Title of questionnaire | |
| Category | Classifier ID | |
| Notes | Description, Image link, rich format data | |
| StartDate | Effective date for this instance | |
| EndDate | Expiry date of this instance |
Question Field Dictionary
| ID | primary key | |
| Questionnaire | ID of parent questionnaire | |
| Sequence | number to order question among questions on questionnaire | |
| Question | text problem statement | |
| AnswerType | ID of the suitable answer type | |
| Jump | conditional number to redirect survey question sequence | |
| Notes | Description, images, rich format data | |
| StartDate | Effective date of this question instance | |
| EndDate | Expiry date of this instance |