Math4Team/RIT/Projects/Question Support API/Data Model

From Sugar Labs
Jump to: navigation, search

Data Model

Here is a potential data model: (It was built for a corporate medical department's medical records. I've already renamed Clinic and Provider to School and Teacher.)

QuestionERDiagram.PNG

Table Dictionary

Questionnaire A collection of questions that might be used in a Survey, Quiz, Exam, etc., or when its key appears in the Category field, a group, class, or category of Questionnaires (a recursive entity)
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 in time instance, at which Answers to Questions or problems are gathered. Survey events can reference other surveys, such as follow-up Surveys (a recursive entity).
Response An event in time instance, at which the Student provides an answer to a question on a Survey or Quiz, etc.
School An organization
Person An individual, such as a Teacher, Student, etc.


Questionnaire

A collection of questions that might be used in a Survey, Quiz, Exam, etc.,
or when its key appears in the Category field making a recursive entity,
a group, class, or category of Questionnaires
ID primary key
Title Short name for questionnaire
Category Category ID, the ID of a Questionnaire group, class, or category of Questionnaire (the parent of a recursive relationship with other Questionnaire records)
Notes Description, Image link, rich format data
StartDate Effective date for this instance of the Questionnaire
EndDate Expiry date of this instance


Question

A problem seeking an answer
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


Answer

A potential solution to the problem
ID primary key
Question_ID ID of parent question
Sequence number to order answer among answer choices for question
Answer text of solution or answer
Notes Description, images, rich format data
StartDate Effective date of this answer instance
EndDate Expiry date of this instance


AnswerType

The class of answer suitable for the problem or question
ID primary key
AnswerType text for the class of answer. Example, text, numeric, multiple choice, tabular, yes/no, etc.
Category ID for class of answer type


Survey

An event in time instance, at which Answers to Questions or problems are gathered. Survey events can reference other surveys, such as follow-up Surveys (a recursive entity).
ID primary key
BaseID ID of parent Survey. Used to identify families of Surveys, such as version
School ID of the School or organization sponsoring this Survey instance
Teacher ID of Person extending this instance of the survey or quiz
Student ID of the Person taking this instance of the survey or quiz
Notes Description, images, rich format data for this instance of the survey or quiz
DateTime DateTime that this Survey instance was taken
ReviewDate Date that this Survey instance was reviewed by the Teacher
ChangeDate Date that this instance of the Survey was changed (reasons are provided in the Response record).


Response

An event in time instance, at which the Student provides an answer to a question on a Survey or Quiz, etc.
ID primary key
Answer_ID ID of selected answer (when one of a choice)
Question_ID ID of the Question instance for this Response instance
Survey_ID ID of the parent Survey or Quiz instance for this Response
Response text of Response
ResponseValue numerical Response
Notes Description, images, rich format data for this Response
ChangeDate DateTime that this instance of the Survey was changed, i.e., initial response, update by Student, override by Teacher, etc.
ChangePerson ID of Person who changed this Response instance, i.e., Student, Teacher
ChangeReason text reason this Response instance was changed, i.e., initial response, update by Student, override reason


School

An organization
ID primary key
School School or organizational name


Person

An individual, such as a Teacher, Student, etc.
ID primary key
Last Name Family name for Person
First Name Primary name for Person


Comments

Authorship and history attributes for Questions could be provided through a new Person ID field in Questionnaire and recursive links.

For reference, here is the Moodle Question database structure.