Math4Team/RIT/Projects/Question Support API/Data Model - Revision history

FGrose: highlight recursive entities

2012-06-08T02:40:04Z

highlight recursive entities

← Older revision		Revision as of 22:40, 7 June 2012
Line 9:		Line 9:
	\|Answer \| A potential solution to the problem		\|Answer \| A potential solution to the problem
	\|AnswerType \| The class of answer suitable for the problem or question		\|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 \| 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.		\|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		\|School \| An organization
Line 16:		Line 16:
	====Questionnaire====		====Questionnaire====
	: '''''A collection of questions that might be used in a Survey, Quiz, Exam, etc.''''',		: '''''A collection of questions that might be used in a Survey, Quiz, Exam, etc.''''',
	:: or when its key appears in the Category field,		:: or when its key appears in the Category field making a recursive entity,
	: '''''a group, class, or category of Questionnaires'''''		: '''''a group, class, or category of Questionnaires'''''
	{{Definition_table		{{Definition_table
Line 59:		Line 59:
	}}		}}
	====Survey====		====Survey====
	: '''''An event in time instance, at which Answers to Questions or problems are gathered'''''		: '''''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).
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key

FGrose: repeat table definitions with each table

2012-06-08T02:29:33Z

repeat table definitions with each table

← Older revision		Revision as of 22:29, 7 June 2012
Line 5:		Line 5:
	====Table Dictionary====		====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., 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		\|Question \| A problem seeking an answer
	\|Answer \| A potential solution to the problem		\|Answer \| A potential solution to the problem
	\|AnswerType \| The class of answer suitable for the problem or question		\|AnswerType \| The class of answer suitable for the problem or question
	\|Survey \| An event instance ~~of collecting~~ Answers to Questions or problems		\|Survey \| An event in time instance, at which Answers to Questions or problems are gathered
	\|Response \| An event instance of the Student ~~providing~~ an answer to a question on a Survey or Quiz, etc		\|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		\|School \| An organization
	\|Person \| An individual, such as a Teacher, Student, etc.		\|Person \| An individual, such as a Teacher, Student, etc.
	}}		}}
	====Questionnaire====		====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'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
	\|Title \| Short name for questionnaire		\|Title \| Short name for questionnaire
	\|Category \| ~~Classifier~~ ID, the ID of a Questionnaire class or category of 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		\|Notes \| Description, Image link, rich format data
	\|StartDate \| Effective date for this instance of the Questionnaire		\|StartDate \| Effective date for this instance of the Questionnaire
Line 25:		Line 28:

	====Question====		====Question====
			: '''''A problem seeking an answer'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
Line 37:		Line 41:
	}}		}}
	====Answer====		====Answer====
			: '''''A potential solution to the problem'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
Line 47:		Line 52:
	}}		}}
	====AnswerType====		====AnswerType====
			: '''''The class of answer suitable for the problem or question'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
Line 53:		Line 59:
	}}		}}
	====Survey====		====Survey====
			: '''''An event in time instance, at which Answers to Questions or problems are gathered'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
Line 65:		Line 72:
	}}		}}
	====Response====		====Response====
			: '''''An event in time instance, at which the Student provides an answer to a question on a Survey or Quiz, etc.'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
Line 79:		Line 87:

	====School====		====School====
			: '''''An organization'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key
Line 84:		Line 93:
	}}		}}
	====Person====		====Person====
			: '''''An individual, such as a Teacher, Student, etc.'''''
	{{Definition_table		{{Definition_table
	\|ID \| primary key		\|ID \| primary key

FGrose at 02:01, 8 June 2012

2012-06-08T02:01:22Z

← Older revision		Revision as of 22:01, 7 June 2012
Line 1:		Line 1:
	~~{{TOCright}}~~
	===Data Model===		===Data Model===
	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.)		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.)
	[[Image:QuestionERDiagram.PNG\|left]]
	~~Authorship and history attributes for Questions could be provided through a new Person ID field in Questionnaire and recursive links.~~		[[Image:QuestionERDiagram.PNG\|left]]<br clear="all">
	~~: The Moodle [http://docs.moodle.org/en/Development:Question_database_structure Question database structure].~~
	====Table Dictionary====		====Table Dictionary====
	{{Definition_table		{{Definition_table
Line 91:		Line 89:
	\|First Name \| Primary 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 [http://docs.moodle.org/en/Development:Question_database_structure Question database structure].

FGrose at 01:45, 18 April 2009

2009-04-18T01:45:00Z

← Older revision		Revision as of 21:45, 17 April 2009
Line 1:		Line 1:
			{{TOCright}}
	===Data Model===		===Data Model===
	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.)		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.)

Enimihil: Move data model to its own page.

2009-04-17T18:04:05Z

Move data model to its own page.

New page

===Data Model===
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.)
[[Image:QuestionERDiagram.PNG|left]]
Authorship and history attributes for Questions could be provided through a new Person ID field in Questionnaire and recursive links.
: The Moodle [http://docs.moodle.org/en/Development:Question_database_structure Question database structure].
====Table Dictionary====
{{Definition_table
|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====
{{Definition_table
|ID | primary key
|Title | Short name for questionnaire
|Category | Classifier ID, the ID of a Questionnaire class or category of Questionnaire
|Notes | Description, Image link, rich format data
|StartDate | Effective date for this instance of the Questionnaire
|EndDate | Expiry date of this instance
}}

====Question====
{{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
}}
====Answer====
{{Definition_table
|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====
{{Definition_table
|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====
{{Definition_table
|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====
{{Definition_table
|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====
{{Definition_table
|ID | primary key
|School | School or organizational name
}}
====Person====
{{Definition_table
|ID | primary key
|Last Name | Family name for Person
|First Name | Primary name for Person
}}