A
PROJECT REPORT
ON
“Library Managament system”
Submitted By
Mr. Kashid jayesh krishna
Mr.kere nikhil ashok
Guided By
Mrs.Deshmukh mam
Mr.Kawade S.N.
Ms.Gite D.P
In partial fulfilment of the award of the degree
of
T.Y.B.Sc. (Computer Science)
of
Sangamner Nagarpalika Arts, D.J.Malpani Commerce & B.N Sarda
Science College(Autonomous), Sangamner
(Affiliated to Savitribai Phule Pune University)
DURING ACADEMIC YEAR
2023-2024
INDEX
Sr.No. Title
1. Acknowledgement.
2. Introduction
- Problem Statement
3. System analysis
- Existing systems
- Limitations of existing systems
4. Implementation details
- Software-Hardware specifications
5. System Design
- Data Dictionary
ACKNOWLEDGEMENT
I would like to express my sincere gratitude and appreciation to
everyone who contributed to the successful completion of the Library
Management System project.
First and foremost, I am deeply thankful to our project supervisor Mrs
deshmukh madam, whose guidance, encouragement, and valuable
insights were instrumental throughout the development process. Your
expertise and support significantly enhanced the quality of this project.
I am also grateful to our team members for their hard work, dedication,
and collaboration. Each member played a crucial role in different
aspects of the project, from system design and implementation to
testing and documentation. Together, we overcame challenges and
achieved our goals effectively.
Furthermore, I would like to extend my thanks to Mrs.Deshmukh mam
for providing the necessary resources, facilities, and opportunities that
enabled us to work on this project and gain valuable experience in
software development.
Last but not least, I want to acknowledge the support and
understanding of our families and friends who stood by us during this
endeavor, offering encouragement and motivation.
Thank you to everyone involved for your contributions and
commitment to excellence.
Problem Definition
Book Cataloging: The system will allow librarians to add, edit,
and delete books from the library catalog. Each book entry will
include details such as title, author, ISBN, genre, and availability
status
Book Checkout and Return: Members can search for books in the
catalog and check them out using their membership ID. The system
will track due dates, send reminders for overdue books, and handle
book returns.
User Authentication and Access Control: Implement secure user
authentication mechanisms to ensure that only authorized users
(librarians, administrators, members) can access specific
functionalities based on their roles and permissions.
Responsive Design: Ensure that the system has a user-friendly and
responsive design, accessible via web browsers on desktops,
laptops, and mobile devices.
ER-DIAGRAM:
Feasibility Study:
Technical Feasibility-:
Evaluate the technical aspects of implementing a library
management system, including hardware and software
requirements, compatibility with existing systems, and data
migration strategies.Assess the availability of skilled personnel for
system development and maintenance.
Economic Feasibility -:
Conduct a cost-benefit analysis to determine the financial
feasibility of the project.
Estimate the initial investment required for system
development, implementation, and training.
Calculate the potential cost savings and benefits, such as
reduced operational costs, improved efficiency, and increased
user satisfaction.
Operational Feasibility -:
Evaluate how the new library management system will fit into
the current operational processes.
potential challenges or resistance from users and stakeholders
and propose strategies to address them.
Assess the impact of the new system on daily library operations
and workflows.
Hardware Requirement:
Processor Intel Core i3 CPU
Installed RAM 8.00 GB
Hard disk SSD: 512GB
Software Requirement:
❖ Any one Web browser like Google, Chrome, Mozilla Firefox,
Microsoft Edge, etc.
❖ Operating System: Windows 11, Linux
Data Dictionary :
1)Books
Sr.no Data field Data type size constraint
1 isbn Int 11 Primary key
2 title Varchar 30 Not Null
3 auther Varchar 30 Not Null
4 category Varchar 20 Not Null
5 price int 30 Not Null
6 copies int 30 Bot Null
2)Book_issue_log
Sr.no Data field Data type size constraint
1 Issue_id Int 11 Foreign key
2 member Varchar 200 Not Null
3 Book_isbn Varchar 30 Not Null
4 Due_date date 200 Not Null
5 Last_remainder varchar 200 Not Null
3) Admin
Sr.no Data field Data type size constraint
1 id Int 11 Foreign key
2 username Varchar 90 Not Null
3 password Password 20 Not Null
4)member
Sr.no Data field Data type size constraint
1 id Int 11 Primary key
2 Username Varchar 30 Not Null
3 Password Varchar 30 Not Null
5)Pending_book_request
Sr.no Data field Data type size constraint
1 Reques_id Int 11 Foreign key
2 member Varchar 30 Primary key
3 Book_isbn Int 11 Not Null
4 time time 12 Not Null
5)pending_registration
Sr.no Data field Data type size constraint
1 username Int 11 Primary key
2 password Password 30 Not Null
3 name varchar 30 Not Null
4 email varchar 30 Not Null
5 balance int 20 Not Null
6 time time 30 Not Null
