The Examination System is a comprehensive solution for managing exams in an academic environment. It allows instructors to create exams, students to take them, and the system to evaluate answers automatically.
- Create exams manually by selecting questions from a question bank.
- Automatically generate exams with random questions.
- Define total exam marks, start and end times, and exam type.
- Supports Multiple Choice Questions (MCQ), True/False, and Open-Ended questions.
- Stores correct answers for automated grading.
- Students can register for exams.
- Answers are stored and automatically graded for MCQ and True/False.
- Open-ended answers are reviewed by instructors.
- Automated grading for MCQs and True/False questions.
- Keyword-based evaluation for open-ended answers.
- Instructors can review and override grades.
- Role-based access control for Admin, Training Manager, Instructor, and Student.
- Restricted access to exam records.
- Enforced constraints to maintain data integrity.
The system consists of multiple key modules:
- User Management: Stores user accounts and roles.
- Courses: Contains course details, instructor assignments, and student enrollments.
- Exams: Stores exam metadata (title, type, start time, end time, etc.).
- Questions: Maintains a pool of questions for each course.
- Student Answers: Tracks student responses to exams.
- CreateExam_Manual: Allows manual selection of questions.
- CreateExam_Auto: Generates exams randomly based on predefined parameters.
- InsertStudentAnswers: Handles student answer submissions.
- CalcGradeOfExamForStudent: Computes student grades automatically.
- AddStudentsToExam: Enrolls students in exams.
- Database Installation
- Restore the provided SQL database file.
- Run the provided SQL scripts to create all objects.
- User Management
- Assign roles and permissions as needed.
- Backup & Maintenance
- Configure SQL Server Agent for automatic backups.
For detailed descriptions of tables, stored procedures, functions, triggers, and views, refer to the definitions.txt file included in the project.
| Role | Permissions |
|---|---|
| Admin | Full Access |
| Training Manager | Manage Branches, Tracks, and Students |
| Instructor | Manage Courses, Create Exams |
| Student | Take Exams, View Results |
- Sample data is included in the database.
- Test queries and validation reports are provided in the TestCases.txt file.
- Daily automated backups configured using SQL Server Agent.
- Manual backup scripts are provided for on-demand use.
This document serves as a guide for setting up, using, and maintaining the Examination System. For any additional information, refer to the provided documentation files.