SHRI B.V.V.
SANGHA’S
BASAVESHWARA ENGINEERING COLLEGE BAGALKOTE-587102
2022-2023
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
Report On
“E-SLIP LIBRARY MANAGEMENT SYSTEM”
Mini Project Guide HOD
Prof. S. N. Kugali Dr. S. R. Patil
Submitted by
Team Members Name USN
1. Divya Hiremath 2BA20IS018
2. Sakshi Somani 2BA20IS080
3. Rahemat Jamakhandi 2BA20IS083
SHRI B.V.V. SANGHA’S
BASAVESHWARA ENGINEERING COLLEGE
BAGALKOTE-587102
2022-2023
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
CERTIFICATE
This is to certify that the mini project work entitled “ E-Slip Library Management System” is a bonafide work
carried out by “Divya Hiremath, Sakshi Somani and Rahemat Jamakhandi” of Department of Information
science and Engineering, Basaveshwara Engineering College Bagalkot affiliated to VTU Belgaum during the
academic year 2022-2023 ,the mini project report has been approved as it satisfies the academic requirements
in respect of mini project work.
Mini Project Guide HOD
Prof. S. N. Kugali Dr. S. R. Patil
Project Associates
Team Members Name USN
1. Divya Hiremath 2BA20IS018
2. Sakshi Somani 2BA20IS080
3. Rahemat Jamakhandi 2BA20IS083
Name of Examiner Signature with Date
1. ----------------------------- 1. ---------------------------------
2. ----------------------------- 2. ---------------------------------
3. ----------------------------- 3. ---------------------------------
ACKNOWLEDGEMENT
The satisfaction that accompanies the successful completion of this project would be incomplete without the
mention of the people who made it possible, without whose constant endurance and encouragement would
have made efforts go in vain . We consider privileged to mess gratitude and respect towards all those who
guided us through the completion of this project.
We convey thanks to our guide Prof. S. N. Kugali, Asst. Professor, Department of Information Science and
Engineering, Coordinator Prof. P. K. Deshpande, Asst. Professor, department of Information Science and
Engineering Basaveshwara Engineering College for providing encouragement, constant support and guidance
which was of a great help to complete this project successfully.
We are grateful to Dr. S. R. Patil, Professor and Head of Department of Information Science and Engineering,
Basaveshwara Engineering College for giving us the support and encouragement that was necessary
for completion of this project. We would also like to express our gratitude to Dr. S. S.
Injaganeri Principal, Basaveshwara Engineering College for providing us congenial environment to work
in.
We are grateful to faculty and staff of department of Information Science and Engineering for providing the
facilities which have helped in making in this project a success.
Finally, we would like to thank, our parents, friends and who helped to complete this project directly and
indirectly, for their constant encouragement with moral and material support.
ABSTRACT
E- Slip library management system is a project which aims in developing a computerized all the daily work
of library .This project has many features which are generally not available in normal library management
systems like facility of user login and a facility of admin login .It also has a facility of admin login through
which the admin can monitor the whole system. It has also a facility where student after logging accounts can
see list of books issued date and return date.
Overall, this project of being developed to help the students as well as staff of library the library in the best
way and also reduce the human efforts.
CONTENTS
CHAPTER 1: INTRODUCTION 6
1.1 Motivation
1.2 Objectives
1.3 Scope of project
1.4 Literature Survey
CHAPTER 2: PROBLEM FORMULATION 7
2.1 Introduction
2.2 Present System
2.3 Proposed System
2.4 Problem Statement
CHAPTER 3: REQUIREMENTS 8
3.1 Functional Requirements
3.2 Non-functional Requirements
3.3 Hardware & Software Requirements
CHAPTER 4: DESIGN 9
4.1 Architecture
4.2 Detailed design
4.2.1 Use case diagram
4.2.2 Sequence diagram
CHAPTER 5: IMPLEMENTATION 16
5.1 Flowchart
5.2 Implementation of the project
5.3 Algorithm
CHAPTER 6: TESTING 18
6.1 Different steps of Testing
6.2 Test Cases
Appendix 1: Results
Appendix 2: Snapshots
CONCLUSION 32
References/Websites
CHAPTER 1 – INTRODUCTION
1.1 Motivation
Libraries are essential in a process of giving users access to knowledge. In digital times they are needed more
than ever before. Library systems are written that is why we make a great use of paper. By making paper we
cut trees. It is very harmful for our environment. It is a time consuming process to submit slip a day prior to
issuing book and is tiresome process. For saving our environment as well as for the betterment of librarians
and members of college, we took this step.
1.2 Objectives
It aims in developing a web based system to improve the availability of a book and the librarian can locate
and issue books quickly to maintain daily reports of books issued, renewed and returned, minimizes errors,
increases accuracy and efficiency
It enables the librarian to search the records, track the history and issue the book within minutes. To save time
by a click of button where all activities of the library can be done
To increase the productivity of library workers which enhances reporting and monitoring.
Overall this project of ours is being developed to help the library administration maintain the library in the
best way possible and reduce the human efforts.
1.3 Scope of Project
Any education institute can make use of it for providing information about author , number of volumes, year
of publication , content of the available books etc.
1.4 Literature Survey
1. RFID is an automatic identification technique used for the fast transaction of books, journals or DVDs
using RFID tags and readers. The RFID technology helps in fast issuing ,returning and reissuing of the books.
And the technology helps in direct transaction of information from the tags to the PC of the librarian and in
automatic updating of transactions in the user account.
2. Library Management System provides knowledge and practical perspectives all aspects of management of
libraries and information services, which will prove invaluable to managing a library or information services
cost effectively, while meeting the needs of its users. Library Management System is one of the most tedious
processes, which involves the regular updating of many files and records. As new members enroll for
membership the management has to issue a unique membership code for that member. For this they have to
keep a track of many records such as student details, book details and maintain a number of registers.
3. Adoption and use of open source library management systems in Indian libraries is gaining momentum.
Koha is the first free and open source library automation package. Its excellent features have made it popular
among the user community within a short span of time. This paper provides a brief picture of Koha software
adoption and the users’ perceptions about it in the Indian library scenario and evaluates the satisfaction level
of Indian library professionals with Koha. It is found that the software is popular among the southern states of
India and the number of Koha users in India is growing.
4. The present study is an attempt to investigate the research publications on Library management using
performance metrics at global, national, institutional and author levels. Library Management is a core function
to be performed by Librarians as custodian of information sources and services for the smooth functioning of
libraries. So, research in this area is of utmost importance.
5. Information and Communication Technologies (ICTs) brought significant innovation and improvement to
library services and methods of meeting user needs. And this paper refers about the management of the library
books which is different from the other automated library systems.
CHAPTER 2: PROBLEM FORMULATION
2.1 Introduction
An E-Slip management system is a software that organizes and saves book’s information electronically to
meet the requirements of library, book borrowers and library personnel
It allows them to keep track of all of the books available in the library at any time
E-Slip management supports users by providing the automated system for issuing the books which is
feasible for the user and the one who manages it.
2.2 Present System
In the available online library management system, librarian maintains the details of books on the
register, so to find out the number of the books available in the library they need to go and check entire
entry which makes the process slow. While they need to spend an extra hour to maintain the records of
books. In the present library management system, students have to write book’s name and author’s name
on a piece of paper and submit it to the library. The librarian collects that slip and checks for availability
of the book and issues (if available) the book to the student. After 30 days (2 times renewal) again the
student has to submit the slip to the library for reissuing the same book.
2.3 Proposed System
To solve the inconveniences as mentioned in the existing system, an online library is proposed. The
proposed system contains the following features:
The students will register them through Online Individually each member will have his account
through which he can access the information he needs. Book details like authors, number of copies
totally maintained by library, present available number of books, reference books, non-reference books
etc. all this information can be made handy. Regarding the members designation, number of books was
issued. Issue dates and returns of each member is maintained separately and fine charged if there is
any delay in returning the book. Administrator can add, update the books. Time consuming is low,
gives accurate results, reliability can be improved with the help of security.
2.4 Problem Statement
An E-Slip library Management system is a software to reduce the manual process to search books
according to the availability and issue selected books so as to make it less time consuming .
CHAPTER 3 – REQUIREMENTS
3.1 Functional Requirements
⚫ Login credentials: The system must only allow user with valid Id and password to enter the system
⚫ Query based results: It allows the user to search for books based on title, publication date, author, etc
⚫ Book Issue information: Users can request, reserve, issue or renew a book.
⚫ Updating books: The librarian can add and manage the books information as required.
3.2 Non-Functional Requirements
⚫ System ensures security through authentication
⚫ System will maintain reliability, where the application would efficiently store all information related to
process.
⚫ System is more scalable and flexible as compared to manual system.
3.3 Hardware & Software
SOFTWARE REQUIREMENTS
• Operating system- Windows 7 is used as the operating system as it is stable and supports
more features and is more user friendly
• Database MYSQL is used as database as it easy to maintain and retrieve records by simple
queries which are in English language which are easy to understand and easy to write.
• Development tools and Programming language- HTML is used to write the whole code and
develop web pages with CSS, JavaScript for styling work and PHP for sever side scripting.
HARDWARE REQUIREMENTS
Intel core i5 2nd generation is used as a processor because it is fast than other processors an provide
reliable and stable and we can run our pc for long-time. By using this processor, we can keep on
developing our project without any worries.
Ram 1 GB is used as it will provide fast reading and writing capabilities and will in turn support
in processing
CHAPTER 4 – DESIGN
4.1 Architecture
The system which including the application layer, business layer and then the data-link layer accordingly
where the process of user registration with the valid user and password and having the different activities like
profile view, checking the available books and also updating the password. And the system having the
relationship between the student, admin and book where the different transactions are taking place between
these according to the requirement and then the data-link layer consisting the different tables which are present
in the database with the tables like authors, issuing the book, login table and then the student table which
makes the system more organized and well-structured and feasible with many advantages.
PROPOSED SYSTEM ARCHITECTURE
Existing system does not have any facility of teachers login or student login whereas proposed system
will have a facility of student login as well as teacher’s login. Existing system does not have a facility of
online reservation of books whereas proposed system has a facility of online reservation of books.
Existing system does not have any facility of online notice board where description of workshops
happening in our college as well as nearby colleges is being provided. Existing system does not have
any facility to generate student reports as well as book issue reports whereas proposed system provides
librarian with a tool to generate reports. Existing system does not has any facility for book request and
suggestions whereas in proposed system after logging in to their accounts student can request books as
well as provide suggestions to improve library
DIAGRAM
Fig.1: Process Diagram
4.2 Detailed Design
User Interface Design
The complete website focuses more on efficiency in understanding the Voice recognition than the look and
feel of the system as the system is primarily developed for the blind people to whom the look and feel won’t
be of that primary importance as the efficiency of understanding the prompting would be.
Database Design
Our system maintains a database for user validation and storing mails of the user. There are a total of five
tables. The Inbox, Sent-Mail schemas will store all mails of the respective service that belongs to that
particular user.
System Design
TABLE DESIGN
VARIOUS TABELS TO MAINTAIN INFORMATION
Table 1: Admin table
Table 2: Table tblauthors track the details of authors
Table 3: Table tblcategory track the record of category
Table 4: Table tbalbooks for books records
Table 5: Table tblstudents for students record and student login details.
Table 6: Table tblissuedbookdetails for maintain issued book and returned book record
System Design Diagram
Fig. 2: System Design Diagram
4.2.1 Use Case Diagram
A case diagram at its simplest is a simplest of a user’s interaction with the system and depicting the
specifications of a user case. A user case diagram can portray the different types of users of a system and
various ways that they interact with the system.
Fig. 3: Admin login
Fig. 4: Students after login
4.2.2 CLASS DIAGRAM
Fig. 5: Class diagram
4.2.3 SEQUENCE DIAGRAM
Fig.6: Sequence Diagram
CHAPTER 5- IMPLEMENTATION
5.1 Flow Chart
• Login: This is the very first page and will ask user to enter login credentials.
• Dashboard: after successful login user will be redirected to main page.
• User can view the issued books, updating the profile and changing the password.
Fig.6: Flowchart
5.2 Implementation of the Project
The system includes following modules
Admin Module
• Admin Dashboard
• Admin can add/update/ delete category
• Admin can add/update/ delete author
• Admin can add/update/ delete books
• Admin can issue a new book to student and also update the details when student return book
• Admin can search student by using their student ID
• Admin can also view student details
• Admin can change own password
Student Module
• Student can register yourself and after registration they will get student id
• After login student can view own dashboard.
• Student can update own profile.
• Student can view issued book and book return date-time.
• Student can also view the available books in the library.
• Student can also change own password.
• Student can also recover own password.
5.2.1 Algorithm:
Step 1: Start (login page)
Step 2: User should enter the username and password.
Step 3: Get the updates about the books
Step 4: If the entered details are valid it will go to next step, else go back to the first step.
Step 5: Go to the dashboard.
Step 6: The user can have the options like profile view, changing the password and available books
Step 7: Logout.
Step 8: Start
Step 9: Admin login
Step 10: Admin should enter the username and password
Step 11: Admin Dashboard
Step 12: Activities the admin can do like adding the books, issuing the books, managing the books,
registered students and changing the password
Step 13: Admin logout
Step 14: Stop.
CHAPTER 6- TESTING
6.1 Different steps of testing
Unit testing-
• In computer programming, unit testing is software verification and validation method in which a
programmer tests if individual units of source code are fit for use.
• The goal of unit testing is to isolate each part of the program first and then testing the sum of its
parts, integration testing becomes much easier.
• In our project, we apply this by testing the various modules of the application and also each features
individually.
Integration testing-
Integration testing is three in software testing in which individual software modules are combined
and tested as groups.
6.2 Test Cases
TEST CASE DESCRIPTION ACTION EXPECTED RESULT ACTUAL RESULT RESULT
Sign up Click on sign up Display the Registration page Same as Pass
button registration page expected
Register Click on Register Check if Match: Home page Same as Pass
password Mismatch :Error expected
entries match message
Login Click on Login Check if Valid: Home page for Same as Pass
(Admin/User) button username and admin/user expected
password are Invalid: Error
valid message for
admin/user
Logout Click on Logout Display the Welcome page Same as Pass
(Admin/user) button Welcome page expected
Table 7: Test cases
CHAPTER 7- RESULTS
7.1 SNAPSHOTS
Home page-
User Signup page-
User Dashboard-
User profile-
Change password-
Listed books-
Admin login-
Dashboard-
Add category-
Manage category-
Update category-
Add author-
Manage author-
Add books-
Manage books-
Update books-
Issue new books-
Manage issue books-
Update issue books-
Registered Students-
Admin change password-
CONCLUSION
Our website provides a computerized version of E-Slip library management system which will benefit the
students as well as the admin of the library. It makes entire process online where student can search books,
staff can generate reports and do book transactions. It also has a facility for student login where student can
login and can see status of books issued as well request for book or give some suggestions.
References/Websites
▪ For PHP
https://www.w3schools.com/php/default.asp
https://www.sitepoint.com/php/
https://www.php.net/
▪ For MySQL
https://www.mysql.com/
http://www.mysqltutorial.org
▪ For XAMPP
https://www.apachefriends.org/download.html
