E-library Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of E-library Management System

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

Functionalities and their descriptions of E-library Management System are as follows:

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

Modules of E-library Management System and their descriptions:

  • Course Module : Manage all the operations of Course
  • Students Module : Manage all the operations of Students
  • Shedules Module : Manage all the operations of Shedules
  • Fees Module : Manage all the operations of Fees
  • Durations Module : Manage all the operations of Durations
  • Books Module : Manage all the operations of Books

Classes and their methods of E-library Management System:

  • Course Methods : addCourse(), editCourse(), deleteCourse(), updateCourse(), saveCourse(), searchCourse()
  • Students Methods : addStudents(), editStudents(), deleteStudents(), updateStudents(), saveStudents(), searchStudents()
  • Shedules Methods : addShedules(), editShedules(), deleteShedules(), updateShedules(), saveShedules(), searchShedules()
  • Fees Methods : addFees(), editFees(), deleteFees(), updateFees(), saveFees(), searchFees()
  • Durations Methods : addDurations(), editDurations(), deleteDurations(), updateDurations(), saveDurations(), searchDurations()
  • Books Methods : addBooks(), editBooks(), deleteBooks(), updateBooks(), saveBooks(), searchBooks()

Database tables and attributes of the E-library Management System:

  • Course Entity : Attributes of Course are course_id, course_student_id, course_registration, course_name, course_type, course_year, course_description
  • Students Entity : Attributes of Students are student_id, student_college_id, student_name, student_mobile, student_email, student_username, student_password, student_address
  • Shedules Entity : Attributes of Shedules are schedule_id, schedule_name, schedule_type, schedule_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
  • Durations Entity : Attributes of Durations are duration_id, duration_course_id, duration_time, duration_date, duration_type, duration_description
  • Books Entity : Attributes of Books are book_id, book_student_id, book_name, book_author, book_publication_date, book_type, book_price, book_description

Database definition of E-library Management System:

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

Super admin functionality of E-library Management System:

  • Admin can add, edit, delete and view the records of Course, Durations, Shedules, Books
  • Admin can manage all the details of Students, Shedules, Fees, Durations
  • Admin can also generate reports of Course, Students, Shedules, Fees
  • Admin can search the details of Course, Durations, Shedules, Books
  • Admin can apply different level of filters on report of Course, Shedules, Books
  • Admin can tracks the detailed information of Durations, Books, Course, Students

Report of E-library Management System:

  • Generates the report on Shedules,Fees,Course,Students,Durations,Books,
  • Fees,Durations,Books 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,Durations,Books
  • Excel Sheet report has also been integrated for Students,Fees,Books
  • You can create the CSV reports for Course,Durations,Shedules

Limitation of E-library Management System

  • Run time report generation is not available in E-library Management System.
  • We have not implemented the dynamic report for Course,Fees,Durations,Students,Shedules,Books
  • This project E-library 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 Course, Fees, Books cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of E-library Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database