Exam Seating Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Exam Seating Management System

Exam Seating Management System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Student,Block,Exam,Seat,Teacher. Admin user can manage all the operations of Seat,Teacher,Student,Room,Block and their details. Admin can create different type of reports of Student,Block,Exam,Seat,Teacher according to their choise and filters. You can Download PHP and MySQL Project Exam Seating Management System with source code and database from this site. We also provide Project Report of Exam Seating Management System.

Functionalities and their descriptions of Exam Seating Management System are as follows:

  • You can search records on various criterias. Such as Student, Exam, Seat, Teacher
  • Create, read, update and delete (CRUD) application has been implemented on Student,Block,Exam,Seat,Teacher
  • Keep the track logs of Block, Room, Seat ect
  • Advance search has been implemented on Block,Room, Seat
  • You can see all the details of the Student, Exam, Room, Seat
  • All the modules Room, Seat, Block,Teacher, Student are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Seat.
  • All the Block,Room, Seat modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Student data.

Modules of Exam Seating Management System and their descriptions:

  • Student Module : Manage all the operations of Student
  • Block Module : Manage all the operations of Block
  • Room Module : Manage all the operations of Room
  • Exam Module : Manage all the operations of Exam
  • Seat Module : Manage all the operations of Seat
  • Teacher Module : Manage all the operations of Teacher

Classes and their methods of Exam Seating Management System:

  • Student Methods : addStudent(), editStudent(), deleteStudent(), updateStudent(), saveStudent(), searchStudent()
  • Block Methods : addBlock(), editBlock(), deleteBlock(), updateBlock(), saveBlock(), searchBlock()
  • Room Methods : addRoom(), editRoom(), deleteRoom(), updateRoom(), saveRoom(), searchRoom()
  • Exam Methods : addExam(), editExam(), deleteExam(), updateExam(), saveExam(), searchExam()
  • Seat Methods : addSeat(), editSeat(), deleteSeat(), updateSeat(), saveSeat(), searchSeat()
  • Teacher Methods : addTeacher(), editTeacher(), deleteTeacher(), updateTeacher(), saveTeacher(), searchTeacher()

Database tables and attributes of the Exam Seating Management System:

  • Student Entity : Attributes of Student are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
  • Block Entity : Attributes of Block are block_id, blocK_ room_id, block_number, block _description
  • Room Entity : Attributes of Room are room_id, room_exam_id, room_number, room_type, room_description
  • Exam Entity : Attributes of Exam are exam_id, exam_student_id, exam_roll_number, exam_date exam_name, exam_type, exam_description
  • Seat Entity : Attributes of Seat are seat_id, seat_student_id, seat_exam_id, seat_number, seat_type, seat_description
  • Teacher Entity : Attributes of Teacher are teacher_id, teacher_exam_id, teacher_name, teacher_mobile, teacher_email, teacher_username, teacher_password, teacher_address

Database definition of Exam Seating Management System:

  • The details of Student is store into the Student tables respective with all tables
  • Each entity (Teacher, Room, Seat, Block, Student) contains primary key and unique keys.
  • The entity Room, Seat has binded with Student, Block entities with foreign key
  • There is one-to-one and one-to-many relationships available between Seat, Exam, Teacher, Student
  • All the entities Student, Seat, Room, Teacher are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Exam Seating Management System tables for fast query execution.

Super admin functionality of Exam Seating Management System:

  • Admin can add, edit, delete and view the records of Student, Seat, Room, Teacher
  • Admin can manage all the details of Block, Room, Exam, Seat
  • Admin can also generate reports of Student, Block, Room, Exam
  • Admin can search the details of Student, Seat, Room, Teacher
  • Admin can apply different level of filters on report of Student, Room, Teacher
  • Admin can tracks the detailed information of Seat, Teacher, Student, Block

Report of Exam Seating Management System:

  • Generates the report on Room,Exam,Student,Block,Seat,Teacher,
  • Exam,Seat,Teacher has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Exam,Seat,Teacher
  • Excel Sheet report has also been integrated for Block,Exam,Teacher
  • You can create the CSV reports for Student,Seat,Room

Limitation of Exam Seating Management System

  • Run time report generation is not available in Exam Seating Management System.
  • We have not implemented the dynamic report for Student,Exam,Seat,Block,Room,Teacher
  • This project Exam Seating Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Student, Exam, Teacher cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Exam Seating Management System

  • We have added all the validations for input value on the modules Student,Block,Room
  • Exam,Seat,Teacher can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Student,Room,Teacher
  • CSRF token has also been implemented on Exam,Block,Student, Seat,Teacher
  • All the Student,Exam,Seat,Block,Room,Teacher has integrated with captcha for spam protections
  • Access level validation has been implemented on Teacher,Seat,Exam
  • Number and character validation has also been implemented on Room,Seat,Student

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database