Enrollment System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Enrollment System

Enrollment 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 Enrollment,Student,Fees,Examination,Login. Admin user can manage all the operations of Examination,Login,Enrollment,Course,Student and their details. Admin can create different type of reports of Enrollment,Student,Fees,Examination,Login according to their choise and filters. You can Download PHP and MySQL Project Enrollment System with source code and database from this site. We also provide Project Report of Enrollment System.

Functionalities and their descriptions of Enrollment System are as follows:

  • You can search records on various criterias. Such as Enrollment, Fees, Examination, Login
  • Create, read, update and delete (CRUD) application has been implemented on Enrollment,Student,Fees,Examination,Login
  • Keep the track logs of Student, Course, Examination ect
  • Advance search has been implemented on Student,Course, Examination
  • You can see all the details of the Enrollment, Fees, Course, Examination
  • All the modules Course, Examination, Student,Login, Enrollment are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Examination.
  • All the Student,Course, Examination 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 Enrollment data.

Modules of Enrollment System and their descriptions:

  • Enrollment Module : Manage all the operations of Enrollment
  • Student Module : Manage all the operations of Student
  • Course Module : Manage all the operations of Course
  • Fees Module : Manage all the operations of Fees
  • Examination Module : Manage all the operations of Examination
  • Login Module : Manage all the operations of Login

Classes and their methods of Enrollment System:

  • Enrollment Methods : addEnrollment(), editEnrollment(), deleteEnrollment(), updateEnrollment(), saveEnrollment(), searchEnrollment()
  • Student Methods : addStudent(), editStudent(), deleteStudent(), updateStudent(), saveStudent(), searchStudent()
  • Course Methods : addCourse(), editCourse(), deleteCourse(), updateCourse(), saveCourse(), searchCourse()
  • Fees Methods : addFees(), editFees(), deleteFees(), updateFees(), saveFees(), searchFees()
  • Examination Methods : addExamination(), editExamination(), deleteExamination(), updateExamination(), saveExamination(), searchExamination()
  • Login Methods : addLogin(), editLogin(), deleteLogin(), updateLogin(), saveLogin(), searchLogin()

Database tables and attributes of the Enrollment System:

  • Enrollment Entity : Attributes of Enrollment are enrollmnet_id, enrollmnet_student_id, enrollmnet_exam_id, enrollmnet_course_id, enrollmnet_title, enrollmnet_type, enrollmnet_description
  • Student Entity : Attributes of Student are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
  • Course Entity : Attributes of Course are course_id, course_student_id, course_registration, course_name, course_type, course_year, course_description
  • Fees Entity : Attributes of Fees are course_fee_id, course_fee_course_id, course_fee_amount, course_fee_total, course_fee_payment, course_fee_type, course_fee_description
  • Examination Entity : Attributes of Examination are exam_id, exam_student_id, exam_roll_number, exam_date exam_name, exam_type, exam_description
  • Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin

Database definition of Enrollment System:

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

Super admin functionality of Enrollment System:

  • Admin can add, edit, delete and view the records of Enrollment, Examination, Course, Login
  • Admin can manage all the details of Student, Course, Fees, Examination
  • Admin can also generate reports of Enrollment, Student, Course, Fees
  • Admin can search the details of Enrollment, Examination, Course, Login
  • Admin can apply different level of filters on report of Enrollment, Course, Login
  • Admin can tracks the detailed information of Examination, Login, Enrollment, Student

Report of Enrollment System:

  • Generates the report on Course,Fees,Enrollment,Student,Examination,Login,
  • Fees,Examination,Login 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 Fees,Examination,Login
  • Excel Sheet report has also been integrated for Student,Fees,Login
  • You can create the CSV reports for Enrollment,Examination,Course

Limitation of Enrollment System

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

Input Data and Validation of Enrollment System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database