Math4Team/RIT/Projects

Question Support API

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

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.

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

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