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

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.)



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

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.

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.