Student Counselling Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Student Counselling Management System

Student Counselling 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,Counsellings,Results,Grade,Merit List. Admin user can manage all the operations of Grade,Merit List,Student,Registrations,Counsellings and their details. Admin can create different type of reports of Student,Counsellings,Results,Grade,Merit List according to their choise and filters. You can Download PHP and MySQL Project Student Counselling Management System with source code and database from this site. We also provide Project Report of Student Counselling Management System.

Functionalities and their descriptions of Student Counselling Management System are as follows:

  • You can search records on various criterias. Such as Student, Results, Grade, Merit List
  • Create, read, update and delete (CRUD) application has been implemented on Student,Counsellings,Results,Grade,Merit List
  • Keep the track logs of Counsellings, Registrations, Grade ect
  • Advance search has been implemented on Counsellings,Registrations, Grade
  • You can see all the details of the Student, Results, Registrations, Grade
  • All the modules Registrations, Grade, Counsellings,Merit List, Student are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Grade.
  • All the Counsellings,Registrations, Grade 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 Student Counselling Management System and their descriptions:

  • Student Module : Manage all the operations of Student
  • Counsellings Module : Manage all the operations of Counsellings
  • Registrations Module : Manage all the operations of Registrations
  • Results Module : Manage all the operations of Results
  • Grade Module : Manage all the operations of Grade
  • Merit List Module : Manage all the operations of Merit List

Classes and their methods of Student Counselling Management System:

  • Student Methods : addStudent(), editStudent(), deleteStudent(), updateStudent(), saveStudent(), searchStudent()
  • Counsellings Methods : addCounsellings(), editCounsellings(), deleteCounsellings(), updateCounsellings(), saveCounsellings(), searchCounsellings()
  • Registrations Methods : addRegistrations(), editRegistrations(), deleteRegistrations(), updateRegistrations(), saveRegistrations(), searchRegistrations()
  • Results Methods : addResults(), editResults(), deleteResults(), updateResults(), saveResults(), searchResults()
  • Grade Methods : addGrade(), editGrade(), deleteGrade(), updateGrade(), saveGrade(), searchGrade()
  • Merit List Methods : addMerit List(), editMerit List(), deleteMerit List(), updateMerit List(), saveMerit List(), searchMerit List()

Database tables and attributes of the Student Counselling 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
  • Counsellings Entity : Attributes of Counsellings are counselling_id, counselling_name, counselling_type, counselling_description
  • Registrations Entity : Attributes of Registrations are registration_id, registration_student_id, registration_course_id, registration_name, registration_type, registration_number, registration_date, registration_description
  • Results Entity : Attributes of Results are result_id, result_student_id, result_name, result_description
  • Grade Entity : Attributes of Grade are grade_id, grade_student_id, grade_name, grade_type, grade_description
  • Merit List Entity : Attributes of Merit List are merit_list_id, merit_list_student_id, merit_list_name, merit_list_type, merit_list_description

Database definition of Student Counselling Management System:

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

Super admin functionality of Student Counselling Management System:

  • Admin can add, edit, delete and view the records of Student, Grade, Registrations, Merit List
  • Admin can manage all the details of Counsellings, Registrations, Results, Grade
  • Admin can also generate reports of Student, Counsellings, Registrations, Results
  • Admin can search the details of Student, Grade, Registrations, Merit List
  • Admin can apply different level of filters on report of Student, Registrations, Merit List
  • Admin can tracks the detailed information of Grade, Merit List, Student, Counsellings

Report of Student Counselling Management System:

  • Generates the report on Registrations,Results,Student,Counsellings,Grade,Merit List,
  • Results,Grade,Merit List 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 Results,Grade,Merit List
  • Excel Sheet report has also been integrated for Counsellings,Results,Merit List
  • You can create the CSV reports for Student,Grade,Registrations

Limitation of Student Counselling Management System

  • Run time report generation is not available in Student Counselling Management System.
  • We have not implemented the dynamic report for Student,Results,Grade,Counsellings,Registrations,Merit List
  • This project Student Counselling 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, Results, Merit List cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Student Counselling Management System

  • We have added all the validations for input value on the modules Student,Counsellings,Registrations
  • Results,Grade,Merit List can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Student,Registrations,Merit List
  • CSRF token has also been implemented on Results,Counsellings,Student, Grade,Merit List
  • All the Student,Results,Grade,Counsellings,Registrations,Merit List has integrated with captcha for spam protections
  • Access level validation has been implemented on Merit List,Grade,Results
  • Number and character validation has also been implemented on Registrations,Grade,Student

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database