Task #532
AirAsia Exam System Table Design
| Status: | Work Completed-End life cycle | Start date: | October 12, 2010 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | October 13, 2010 | |
| Assignee: |  Ngoh Chee Ping | % Done: | 100% | |
| Category: | - | Estimated time: | 15.00 hours | |
| Target version: | - | Spent time: | 15.00 hours |
Description
To do table design for a exam system.
Requirements:-
1) Can handle main category and multiple layer of subcategories for question segregation
2) Can handle true/false, multiple choice, subjective, extended matching, etc
3) To generate exam paper based on preset random selection of questions
4) Every question must have correct answer for marking purpose
5) Must support user to do online exam
6) The same system can also be used for survey questionnaires usage
History
#1
Updated by Ngoh Chee Ping almost 14 years ago
- File New_E_Exam_table_structure.jpg added
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 60
- Estimated time set to 15.00
The requirement can handle multiple layer of subcategories already settle. I added one column in CATEGORY_TABLE, the is SUPER, this is to store the subcategories is belong to which category. By using this i can store how many category also can. We also can get the subcategory easy. For now, almost all requirement already cover except used for survey questionnaires usage. For this still do not know how to design it.
#2
Updated by Ngoh Chee Ping almost 14 years ago
- File New_E_Exam_table_structure_v1.1.jpg added
- % Done changed from 60 to 100
The design for survey also include inside. I also edited the part of create paper and set questions for the paper, and store user answer.
#3
Updated by Tan Lee Yong almost 14 years ago
A Category can have multiple sub-categories
A Category can have many questions
A question belong to a question type
Each question type has its own format
A question can have one or more answer (cater for the question in check box format)
A User can have multiple Paper (can be exam or survey)
A Paper can belong to multiple User
A Paper can have many Questions
A Question can belong to multiple Paper
Each Question has one or more Answer from a User
A User can provide one or more Answer for a Question
#4
Updated by Tan Lee Yong almost 14 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- % Done changed from 100 to 90
#5
Updated by Tan Lee Yong almost 14 years ago
- File Air_Asia_E_Exam_Project.vpp added
#6
Updated by Ngoh Chee Ping almost 14 years ago
got one question, why A User can provide one or more Answer for a Question? If for multiple choice, user choice all answer then, that student also will correct?
#7
Updated by Ngoh Chee Ping almost 14 years ago
- File E_Exam_Database_Structure_image.jpg added
- % Done changed from 90 to 100
The design is finished after discuss.
#8
Updated by Tan Lee Yong almost 14 years ago
- Status changed from Pending Customer Feedback to Work Completed-End life cycle
#9
Updated by Ngoh Chee Ping almost 14 years ago
- File E_Exam_Database_Structure_image_v1.0.jpg added
new table design