Kamala Education Society’s
Pratibha College of Commerce & Computer Studies, Chinchwad,
Pune-19
A
Project Report On
Library Management System “Project Title”
Developed by,
ll/ Seat No: 8774 Student: Name Shubham Patil Roll/ Seat No:8735 Student: Name Atharv N
TYBSC CS(SCIENCE)
Under
Savitribai Phule Pune University (2023-2024)
Kamala Education Society’s
Pratibha College of Commerce & Computer Studies, Chinchwad, Pune-19
Certificate
This is to certify that & have satisfactorily completed the Project
titled “Project Title” for T.Y .BCA(Science) under the Savitribai Phule Pune Uni
Name of Project Guide
Project Guide Program Coordinator
Internal Examiner External Examiner
Date:
ACKNOWLEDGEMENT
Any efforts to produce successful creation require the help. Guidance
and support of many people and their experience. We would like to
express our sincere and heartfelt gratitude to all of them who have
helped us to complete project.
We would like to take this opportunity to thanks all the people who
have directly or indirectly helped in completing this project. We would
like to thank our guide Mrs. Guide Name, for her valuable guidance.
Shubham Patil
Atharv Nigde
Index
Table of Contents
Particulars Page
No.
Abstract (Short Summary of project)
Introduction
Motivation
problem statement
purpose/objective and goals
literature survey
project scope and limitations
System analysis
Existing systems
scope and limitations of existing systems
project perspective, features
stakeholders
Requirement analysis- Functional
requirements,
Performance requirements, security
requirements etc.
System Design
Design constraints
System Model: Using OOSE
Data Model
User interfaces
Implementation details
Software/hardware specifications
Outputs and Reports Testing
Test Plan, Black Box Testing or
Data Validation Test Cases,
White Box Testing or Functional Validation
Test cases and
Results
Conclusion and Recommendations
Future Scope
Bibliography and References
Introduction
Library Management System(LMS) is a project which aims in
developing a computerized system to maintain all the daily work of library. This pro
The admin side manages all the management like adding and
managing categories, authors, books, issued books, and so on. The admin has an im
Objective
The Objective of this System is to reduce effort and increase
convenience in the management of libraries .It will save time in the calculation of fi
Overall, this project of ours is being developed to help students
as well as staff of library to maintain the library in the best way possible and also r
Problem in Existing System
The current system is full of flaws/problems:
Many libraries still use manual processes for tasks like cataloging,
lending, and tracking overdue books. This can be time-consuming, error-prone, an
Paper is wasted.
A lot of time is consumed in the process of searching a book, making
its entry, and retrieving any previous record. Availability of books cannot be assur
reduced overall value of the library.
Need for System
The need for a system project stepout from the fact that libraries have
to manage a vast amount of information, and manual systems are inefficient and err
Overall LMS has become an essential tool for any modern library.It helps to do the
Scope of Proposed System
The System we developed comes with all solutions to the drawback of
the previous system.
Search books from login panel.
A panel for users to check the availability and issued books.
Easy login and registration System. Automated Fine System
One-click book Issue. Easily return book
Modules
Online library Management System divided in two modules–
Student Admin
Admin Features:- Admin Dashboard
Admin can add/update/ delete category Admin can add/update/ delete author Admin
Admin can issue a new book to student and also update the details when student ret
Admin can search student by using their student ID Admin can also view student de
Admin can change own password
Students Features
Student can register yourself and after registration they will get
studentid. After login student can view own dashboard. Students can also view the l
Student can update own profile.Student can view issued book and book return date-
Student can also change own password.
Student can also recover own password.
Feasibility Study
Feasibility study enables proper decisions to be made over the
progress of the project, by studying various aspects of feasibility
associated with it are as follows:
Cost: as it is a web-based project it needs to be hosted over the server
to be accessed by users, but the efficiency which comes with the
product shadows this cost, as it reduces money being spent on human
resources
Time: The time invested in this project is also justifiable as keeping
the yield into consideration.
Technical: All technological tools used to make this project are
conventional easy-to-use ones, and they are easy to maintain too.
This project can be easily upgraded and maintained as it is designed
in a standard manner and is easy to understand.
Fact-finding Techniques
To gather information for the feasibility study and to identify
requirements for the Library Management System, fact-finding
techniques can be used. These include:
1. Interviews: Conducting interviews with stakeholders, including
project managers, team members, and users, to gather their
opinions, requirements, and concerns.
2. Observation: Observing how project documentation is currently
managed, including the processes, tools, and challenges involved.
3. Questionnaires: Distributing questionnaires to stakeholders
to gather their opinions and requirements.
4. Document analysis: Analyzing existing project documentation,
such as project plans, requirements documents, and design
documents, to identify requirements and areas for improvement.
Overall, conducting a feasibility study and using fact-finding
techniques can help ensure that the Library Management System
is designed to meet the needs of the organization and to provide an
efficient and effective way to manage project documentation.
Hardware and Software Requirement
Hardware and software requirements for a library management
system can vary depending on the specific features and functions of the system. How
Processor: Pentium 4 /Intel core i3 or Higher.
Ram: Minimum 2GB or Higher. 3.Rom:Minimum 50 GB or Higher.
4.Network : A fast and reliable broadband connection. 5.HardDisk:500 GB.
Software Requirements:
1.Operating System: The library management system can be hosted
on any operating system such as Windows, linux etc
2. Database: we have used MYsql for authentication as database
3. Programming Languages: The website is built using language for
Front end: HTML, CSS, JavaScript and Back end: MySQL, PHP.
4. Web Browser: The website can be hosted on any browser
compatible with web server such as Chrome, Mozilla Firefox etc.
5.WebServer:Webserver such as Xampp / Apache is used to host the
website.
Design Specification
UML Diagrams
Use Case Diagram:
ER Diagrams
Class Diagram:-
Sequence Diagram:-
Activity Diagram:-
Deployment Diagram:-
Data Dictionary
Table Design:
A library management system typically requires several tables to store
information about books, borrowers, library transactions, and other related data. He
Table Users/Student
This table stores the information of the users of the system.
Sr.no Field name Data type Constraint
1 Id Int Primary key
2 Studentid Varchar Default Null
3 FullName Varchar Default Null
4 Emailid Varchar Default Null
5 MobileNumber Char Default Null
6 Password varchar Default Null
7 Status Int Default Null
8 RegDate timestamp Default Null
Table Author
This table stores information about authors of the books in the library.
Sr.no Field name Data type Constraint
1 Id Int Primary key
2 AuthorName Varchar Default Null
3 CreationDate Timestamp Default Null
4 UpdationDate Timestamp Default Null
Table Books
This table stores information about books in the library, including the
book's title, author, publisher, ISBN, and other relevant data.
Sr.no Field name Data type Constraint
1 Id Int Primary key
2 BookName Varchar Default Null
3 CatId int Default Null
4 AuthorId Int Default Null
5 ISBNNumber Varchar Default Null
6 BookPrice Decimal Default Null
7 bookImage Varchar Not Null
8 isIssued Int Default Null
9 RegDate timestamp Default Null
Table Admin
This table stores information of the admin who maintains or manages
the library and issues or returns the book
Sr.no Field name Data type Constraint
1 id int Primarykey
2 FullName varchar Default Null
3 AdminEmail varchar Default Null
4 UserName Varchar Not Null
5 Password Varchar Not Null
6 UpdationDate timestamp Not Null
Table Category
This table stores information of the category of the books in the
library
Sr.no Field name Data type Constraint
1 Id Int Primary key
2 CategoryName Varchar Default Null
3 Status Int Default Null
4 CreationDate Timestamp Default Null
5 UpdationDate Timestamp Default Null
Table Issuedbooks
This table stores the information about transactions in the library
including bookid , studentid etc
Sr.no Field name Data type Constraint
1 Id int Primarykey
2 BookId Int Default Null
3 StudentId Varchar Default Null
4 IssueDate Timestamp Default Null
5 ReturnDate Timestamp Default Null
6 ReturnStatus Int Default Null
7 Fine Int Default Null
Sample Input and Output Screen:
Home Page
Testing Strategy
SYSTEM TESTING
The aim of the system testing process was to determine all
defects in our project .The program was subjected to a set of test
inputs and various observations were made and based on these
observations it will be decided whether the program behaves as
expected or not. Our Project went through two levels of testing
1. Unit testing
2. Integration testing
INTEGRATION TESTING
In this type of testing we test various integration of the project module
by providing the input .The primary objective is to test the module
interfaces in order to ensure that no errors are occurring when one
module invokes the other module.
UNIT TESTING
Unit testing is undertaken when a module has been created and
succesfully reviewed .In order to test a single module we need to
provide a complete environment ie besides the module we would
require
The procedures belonging to other modules that the module under test calls
Non local data structures that module accesses
A procedure to call the functions of the module under test with appropriate paramete
Limitations
There are not many limitations of the project but it includes some
limitations, which are listed below or are as follows:
Limited scope: LMS projects have a limited scope, as it focuses
mainly on the tasks associated with managing library materials. They
may not able to to meet or modify large organizational needs.
Cost: Implementing an LMS can be expensive, particularly for
smaller libraries or those with limited budgets. In addition to the
initial purchase and implementation costs, ongoing maintenance and
support can be costly.
Technical Knowledge: LMS software can be complex, requiring staff
to be trained in its use. This can take time and resources, and staff
turnover can result in the need for ongoing training.
Technical issues: LMS project may experience technical issues, such
as software bugs ,loading errors and crashes. It may face
compatibility issues with other sytem. These issues can cause delays
or disruptions in library services.
Security: LMS projects often involve collecting and storing User
information, such as names, addresses, and borrowing history. Hence
it cab be vulnerable to cyber attacks and data breaches which can
degrade user trust.
Future Enhancement
There are many enhancements that can be made to a library
management system project. Here are some examples:
1) Mobile Optimization: In this module student can check availability
of the book from the app. The following are the sub module in the
user module. Student can search for book from his app if it is
available or not.
2)Reminder: Reminder can be added for the user to return
book before the collection date on his phone.
3) Online use of the library can be good feature for the Library
Management system.
4) Advanced fine payment system can be added.
5) Artificial intelligence: One can integrating AI technology into
LMS project so that it can enhance the system's ability to make
recommendations, suggest relevant materials, and provide
personalized user experiences.
Overall, there are many potential enhancements that can be made to
LMS projects to improve its functionality, accessibility, and user
experience.
Conclusion
The Library management sytem provides a convenient and efficient
way for user and admin to issue ,return manges books. It provides a computerized v
benefit the students as well as the staff of the library. It makes entire
process online where student can search books, admin can add, edit, and delete bo
This system has been developed in a way to make it very user
friendly.Any person having a basic understanding of computer can
run this system without any pain.
BiblioGraphy
It refers to the books/websites which were gone throught for
completion of this project reports.
youtube.https://youtube.com/
w3schools.https:w3
geeksforgeeks.
Googgoo
Githubgetc
