1

Library management using python

[Link]

This chapter gives an overview about the aim, objectives ,back ground and
operationenvironment of the system.
1.1 PROJECT AIMS AND OBJECTIVES
The project aims and objectives that will be achieved after completion of
this project arediscussed in this subchapter. The aims and objectives areas follows:
 Online book issue
 Online book return
 Request column for librarian for providing new books
 A separate column for digital library
 Insertion of new book by librarian
 Student login page where student can find books issued by him/her and date of return.
 A search column to search availability of books
 A teacher login page where teacher can add any events being organized in the college
and important suggestions regarding books.
1.2 BACKGROUND OF PROJECT

Library Management System is an application which refers to library systems

which are generally small or medium in size. It is used by librarian to manage the library
using a computerized system where he/she can record various transactions like issue of
books, return of books, addition of new books, addition of new students etc. Books and
student maintenance modules are also included in this system which would keep track of
the students using the library and also a detailed description about the books a library
contains. With this computerized system there will be no loss of book record or member
record which generally happens when a non computerized system is used. In addition,
report module is also included in Library Management System. If user’s position is admin,
the user is able to generate different kinds of reports like lists of students registered, list of
books, issue and return reports.

Department of CSE[AI&ML]
 2
Library management using python

1.3 SPECIFICATIONS

Processor Intel core for better performance

Operating system Windows
memory 8GB or more
Hard disk space Minimum 3GB for data base
usage for
future
language Python
Version 3.9.6
Table1.1:hardware specifications

Department of CSE[AI&ML]
 3
Library management using python

[Link] SURVEY

2.1 INTRODUCTION
The survey is a recognized and accepted part of the modern society. It is one of the
means by whichsociety keeps it informed, away of bringing under central situations of
increasing size and complexity of obtaini ng perceptive and standard of com parison. A
survey gives an oversight of a field and is thus distinguishing from a sort of study whi ch
consists of a m icroscopic examination of a turf ; it is a m ap rather than a detailed plan.
The survey must be planned before a start is made.
Most of the research and writings on library management have focused on academic
libraries and only recently has there been more interest in the administration of public
libraries. The skill and style ofpublic Library managers - the directors, branch managers,
and department and service managers who are leading these institutions - strongly affects
the culture of a public library.
Library staff looks to these managers to help them navigate through the rapid changes
that are occurring in public libraries as these changes in technology, roles, and user
expectations strongly alter their daily routines of public service. Contemporary library
managers need a wider array of skills and attributes than their earlier and more traditional
counterparts and will need to seek continual professionaldevelopment to remain effective
as public libraries transition into the twenty-first century.
These managers will also need to distinguish between management and leadership
skills and learn to dentify and mentor leaders within their staff who can assist in the
transition. This paper is a brief scan of the literature currently available on managing
libraries and includes information on academic as wellas public libraries due to the above-
mentioned lack of public library material. Weiner reviewed the literature extant on
leadership in academic libraries and surveyed materials on "recruitment, leadership
potential dentification, career development, roles and responsibilities, and characteristics
and management style" (2003, p.).
Since she chose to focus on leadership as well as management attributes, her review
encompasses materials on library directors as well as university librarians. A discussion of
the changes and trends affecting academic libraries is valuable as it provides the context
of the article and helps to enlighten readers who might not be familiar with the academic
environment. Research studies and models, other literature reviews, and books and articles
Department of CSE[AI&ML]
 4
Library management using python

written are discussed and an extensive bibliography leads the readers to further study.
Hernon and Rossiter (2006) studied the emotional intelligence concepts that are
relevant to university library directors. Their research involved two different activities for
gathering information. They analyzed all of the job advertisements for library directors in
College & Research Libraries News from 2000 to 2004 and looked for any mention of
leadership skills. Then they interviewed universitylibrary directors to compare their career
experiences with the information taken from the advertisements. By comparing the
expectations of search committees with the actual experiences of the directors, they
suggest which emotional intelligence traits are most useful in academic library
management. Theauthors conclude that identifying these traits and helping to "cultivate the
ones deemed most critical" (p. 274) is important for the development of future leaders.
Mullins and Linehan (2006) provided a public library.
Their focus was on whether or not these managers understand and utilize the differing
concepts ofeadership and management. According to their findings, eighty percent of the
respondents did not comprehend the difference in these concepts and focused on
administration and management over eadership skills to accomplish their work. Public
librarians who exhibit an aptitude for leadership shouldbe encouraged to develop and apply
their talents in their field of influence.
Sager's (2001) writings on identifying the skills and attributes needed in library
administration derive from his work as a library executive recruiter. He has conversed with
many library administrators, board members and trustees, search committees, and job
candidates and proposes that successful managers need mot only the traditional skills that
have defined a library manager's role.
Although his work is based on experience and not research, there is value in his
discussion of what he believes are the most important skills and attributes because it is
based on his extensive interaction with the groups listed above. Throughout the article
"Evolving Virtues," he also creates his own list of traits that he believes will emerge in the
future and ends the article by listing some methods for library managers to develop these
newer skills. Hernon, Powell, and Young (2003) conducted research in academic and
public ibraries to assess the qualities that library directors need in order to be uccessful in
their careers and have written an effective book on the results of their work.
The Next Library Leadership: Attributes of Academic and Public library Directors
discusses in great detail the leadership qualities and styles, managerial qualities, personal
qualities, and knowledge areas that are desirable for a library director in either a public or
Department of CSE[AI&ML]
 5
Library management using python

academic setting. A Delphi study was used to gather data from public library directors via
email to identify and rank leadership attributes and the results of their research are defined
through narratives as well as in tabular form.
Results from the study helped the authors to rank the most beneficial managerial
attributes as the ability to work effectively with library boards and staff and to advocate
for library in the community. Desirable personal attributes included integrity, vision, and
effective oral, written, and interpersonal communication skills. Directors must also possess
knowledge of trends, innovations, and current librarybest practices and be able to plan
effectively for the future.
Although little management and leadership research exists that identifies specifically
the skills and attributes needed by public library managers, it is possible to transfer
knowledge from the academic library field. However, researchers with an interest in the
future of public libraries should note the dearthof information and work to increase the
available knowledge. Public library administrators and leaders, as well as schools "brary
and information studies should also note the missing literature and contribute to the
process.
2.2 OBJECTIVES OF THE LITERATURE SURVEY:
The main objective of the Literature survey is to: (i) know who writes, what and where
about (yourtopic name); (ii) identify the tools and sources of (your topic name), and (iii)
prepare the relevant bibliographic entries with abstract of the related topic.
2.3 PURPOSE OF THE LITERATURE SURVEY:
The literature review pla ys a very important role in the res earch process. It is a so urce
from whereresearch ideas are draw n and developed into concepts and finally theories. It also
provides the researcher a bird’s eye view about the research done in that area so far.
Depending on what is observed in the literature review, a research er will unders tand where
his/her research stands. Here in this literature survey, all primary, secondary and tertiary
sources of information were searched.
2.4 METHODOLOGY:
As websites and consul ted various em inent For preparing of this literature survey I
have taken a lot of steps for collecting the articles about the (your topic name). First
Sir/madam, told us about the what is literature survey and what are the steps involved for
prepar ing it. He had given m e the topic – “( your topic name)” for the survey. I went to
the de partment lib rary and ce ntral lib rary for collectinga rticles.

Department of CSE[AI&ML]
 6
Library management using python

[Link] AND DESIGN

3.1 SOFTWARE REQUIREMENTS
 Operating system-Windows 7 is used as the operating system as itis stable and supports
more featuresand is more user friendly.
 Database MYSQL-MYSQL is used as database asset 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 Programminglanguage-HTMLis used to write the whole code and

develop webpages with CSS, JavaScript for styling work and php for sever side scripting.

3.2 HARDWARE REQUIREMENTS

 Intelcorei5 2ndgeneration is used as a processor because it is fast than other processors an
provide reliableand stable and we can run our pc for long time. By using this processor, we
can keep on developing ourproject without any worries.
 Ram 1gb is used as it will provide fast reading and writing capabilities and will intern
support in processing.
3.3 USER LOGIN
Description of feature :
This feature used by the user to login into system. They are required to enter user id
and passwordbefore they are allowed to enter the system. The user id and password will
be verified and if invalid

id is their user is allowed to not enter the system.

Functional requirements :
 User id is provided by the register.
 The system must only allow user with valid id and password to enter the system.
 The system performs authorization process which decides what user level can access to.
 The user must be able to logout after they finished using system.
REGISTER NEW USERDescription of feature:
This feature can be performed by all users to register new user to create account.
Functional requirements:
 System must be able to verify information.

Department of CSE[AI&ML]
 7
Library management using python

 System must be able to delete information if information is wrong.

3.4 REGISTER
New Book Description of feature:
 This feature allows to add new books to the library

Functional requirements:

System must be able to verify information.

 System must be able to enter number of copies into table.
 System must be able to not allow two books having same book id.
3.5 S
SEARCH BOOKIDescription Feature:
This feature is found in book maintenance part . we can search book based on book id ,
book name , publication or by author name.
Functional requirements:
- System must be able to search the database based on select search type.

- System must be able to filter book based on keyword entered.

- System must be able to show the filtered book in table view.
3.6 I
ISSUE BOOKS AND RETURN BOOKS Description feature:
This feature allows to issue and return books and also view reports of book issued.
Functional requirements :
 System must be able to enter issue information in database.
 System must be able to update number of books.
 System must be able to search if book is available or not before issuing books
 System should be able to enter issue and return date information.
3.7 DATAFLOW DIAGRAMS
After entering to the home page of the website, teacher can choose the TEACHER
LOGIN optionwhere they are asked to enter username &password ,and if he/she is a valid
user then a Teacher login page will be displayed.

Department of CSE[AI&ML]
 8
Library management using python

3.8 DATA FLOW DIAGRAM FOR STUDENT LOGIN

After entering to the home page of the website, student can choose the
STUDENTLOGIN option where they are asked to enter username &password ,and if
he/she is a valid user then a student login page will be displayed.

3.1 DATA FLOW DIAGRAM FOR BOOK ISSUE

It is the second level Data Flow Diagram where after entering STUDENTLOGIN
page he/she can select a book issue option where after entering the book detail, he/she can
select the book issue option and if the maximum no of books issued limited books then
request will be sent to the librarian who will approve the book issue.

3.2 DATA FLOW DIAGRAM FOR BOOK ISSUE

gives insight into the inputs and outputs of each entity and the process itself. DFD

Department of CSE[AI&ML]
 9
Library management using python

does not have control flow and no loops or decision rules are present. Specific operations
depending on the type of data can be explained by a flowchart. It is a graphical tool, useful
for communicating with users, managers and other personnel. it is useful for analyzing
existing as well as proposed system.

After the home page login there will be an option of the book search whereafter
entering book detail like author name, publication, book name etc. book details will be
displayed.
Specific operations depending on the type of data can be explained by a flowchart.
It is a graphical tool, useful for communicating with users, managers and other personnel.
it is useful for analyzing existing as well as proposed system.

Fig :database chart for library

3.3 DATA FLOW DIAGRAM FOR ACCOUNT CREATION

One of the met hods used for login and registrat ion system
development is the DFD ( data flow diagram) . It represents the system’ s
major processes and alternat ives that generate the internal flow of data.
Addit ionally, the data was properly categorized to illustrate the login
and registrat ion system structure. Take note that DFD is not part of the Login
and Registrat ion System UML Diagrams, but they complement each other in
explaining the project act ivit ies, behaviours, interact ions, and structure.

Department of CSE[AI&ML]
 10
Library management using python

Fig: admin & student page

Creating an admin and login page for a library management system in Python
involves utilizing basic functionalities for user authentication. Below is a simple example
using Python that demonstrateshow you might implement an admin panel and a login page.
This example uses a dictionary to store user credentials (username and password).
It provides anoption for an admin to log in and access admin functionalities, and for regular
users to log in to the library system.
After the home page login there will be an option of CREATE AN ACCOUNT
where after entering student detail, if all the fields are filled then a request will be sent to
the librarian who will approve him as a registered member of the library.
Data Flow Diagram is the flow of data of a system, or a process is represented by
DFD. It also gives insight into the inputs and outputs of each entity and the process itself.
DFD does not have control flow and no loops or decision rules are present. Specific
operations depending on the type of data can be explained by a flowchart. It is a graphical
tool, useful for communicating with users, managers and other personnel. it is useful for
analyzing existing as well as proposed system.
Creating an admin and login page for a library management system in Python
involves utilizing basic functionalities for user authentication. Below is a simple example
using Python that demonstrateshow you might implement an admin panel and a login page.
This example uses a dictionary to store user credentials (username and password).
It provides anoption for an admin to log in and access admin functionalities, and for regular

Department of CSE[AI&ML]
 11
Library management using python

users to log in to the library system.

Data Flow Diagram is the flow of data of a system, or a process is represented by
DFD. It also gives insight into the inputs and outputs of each entity and the process itself.
DFD does not have control flow and no loops or decision rules are present. Specific
operations depending on the type of data can be explained by a flowchart. It is a graphical
tool, useful for communicating with users, managers and other personnel. it is useful for
analyzing existing as well as proposed system.
Creating an admin and login page for a library management system in Python
involves utilizing basic functionalities for user authentication. Below is a simple example
using Python that demonstrateshow you might implement an admin panel and a login page.

Department of CSE[AI&ML]
 12
Library management using python

[Link]

4.1 PROCEDURAL DESIGN

Department of CSE[AI&ML]
 13
Library management using python

4.2 C

CODE FOR IMPLEMENTION OF LIBRARY MANAGEMENT

USINGPYTHON:
import tkinter as tk
from tkinter import messagebox

class LibraryManagement: def init (self, master):

[Link] = master
[Link]("Library Management System") [Link]("400x400")
[Link](bg='#708090')

[Link] = [] self.lend_list = []

# Labels
self.login_label = [Link]([Link], text="Library Management System",
font=("Helvetica", 16), bg='#708090', fg='white')
self.login_label.pack()
self.username_label = [Link]([Link], text="Username", font=("Helvetica",
12), bg='#708090', fg='white')
self.username_label.pack()
self.username_entry = [Link]([Link], font=("Helvetica", 12))
self.username_entry.pack()
self.password_label = [Link]([Link], text="Password", font=("Helvetica",
12), bg='#708090', fg='white')
self.password_label.pack()
self.password_entry = [Link]([Link], font=("Helvetica", 12), show="*")
self.password_entry.pack()

1
2
)

Department of CSE[AI&ML]
 14
Library management using python

# [Link], text="Login", command=[Link], font=("Helvetica",

L self.login_button.pack() # Register
o self.register_button = [Link]([Link], text="Register",
g command=[Link], font=("Helvetica", 12))
i self.register_button.pack()
n
s [Link] = ""[Link] = ""[Link] = []
e
l def login(self):
f [Link] = self.username_entry.get() [Link] = self.password_entry.get() for
. librarian in [Link]:
l if [Link] == librarian[0] and [Link] == librarian[1]:
o
g self.username_entry.delete(0, [Link]) self.password_entry.delete(0, [Link])
i self.login_label.destroy() self.username_label.destroy() self.username_entry.destroy()
n self.password_label.destroy() self.password_entry.destroy() self.login_button.destroy()
_ self.register_button.destroy() self.library_management_screen() return
b [Link]("Error", "Invalid username or password")
u
t def register(self):
t [Link] = self.username_entry.get() [Link] = self.password_entry.get()
o [Link]([[Link], [Link]]) self.username_entry.delete(0,
n [Link]) self.password_entry.delete(0, [Link])
= def library_management_screen(self):
t self.add_book_label = [Link]([Link], text="Add Book", font=("Helvetica",
k 16), bg='#708090', fg='white')
. self.add_book_label.pack()
B self.add_book_entry = [Link]([Link], font=("Helvetica", 12))
u self.add_book_entry.pack()
t self.add_book_button = [Link]([Link], text="Add Book",
t command=self.add_book,font=("Helvetica", 12))
o self.add_book_button.pack()
n self.remove_book_label = [Link]([Link], text="Remove Book",
( font=("Helvetica", 16),bg='#708090', fg='white')

Department of CSE[AI&ML]
 15
Library management using python

s remove_book_entry = [Link]([Link], font=("Helvetica", 12))

e self.remove_book_entry.pack()
l self.remove_book_button = [Link]([Link], text="Remove Book",
f command=self.remove_book, font=("Helvetica", 12))
. self.remove_book_button.pack()
r self.issue_book_label = [Link]([Link], text="Issue Book",
e font=("Helvetica", 16),bg='#708090', fg='white')
m self.issue_book_label.pack()
o self.issue_book_entry = [Link]([Link], font=("Helvetica", 12))
v self.issue_book_entry.pack()
e self.issue_book_button = [Link]([Link], text="Issue Book",
_ command=self.issue_book, font=("Helvetica", 12))
b self.issue_book_button.pack()
o self.view_books_button = [Link]([Link], text="View Books",
o command=self.view_books, font=("Helvetica", 12))
k self.view_books_button.pack()
_ def add_book(self):
l book = self.add_book_entry.get()[Link](book)
[Link]("Success", "Book added successfully")
a self.add_book_entry.delete(0, [Link])
b
e def remove_book(self):
l
book = self.remove_book_entry.get() if book in [Link]:
.
[Link](book)
p [Link]("Success", "Book removed successfully") else:
[Link]("Error", "Book not found") self.remove_book_entry.delete(0,
a
[Link])
c
k
def issue_book(self):
( book = self.issue_book_entry.get()if book in [Link]:
) self.lend_list.append(book) [Link](book)
[Link]("Success", "Book issued successfully") else:
s [Link]("Error", "Book not found") self.issue_book_entry.delete(0,
e [Link])
l def view_books(self):
f message = "\n".join([Link]) [Link]("Books", message)
. if name == " main ": root = [Link]()

Department of CSE[AI&ML]
 16
Library management using python

[Link]
5.1 INTRODUCTION TO SYSTEM TESTING:
The purpose of testing is to discover errors. Testing is the process of trying
to discover every conceivable fault or weakness in a work product. It provides a way to
check the functionality of components, sub-assemblies, assemblies and/or a finished
product It is the process of exercising software with the intent of ensuring that the Software
system meets its requirements and user expectations and does not fail in an unacceptable
manner. There are various types of test. Each test type addresses a specific testing
requirement.
5.2 TYPES OF TESTING:
5.2.1 Unit testing:
Unit testing involves the design of test cases that validate that the internal program
logic is functioning properly, and that program inputs produce valid outputs. All decision
branches and internalcode flow should be validated. It is the testing of individual software
units of the application .it is done after the completion of an individual unit before
integration. This is a structural testing, that relies on knowledge of its construction and is
invasive. Unit tests perform basic tests at component level and test a specific business
process, application, and/or system configuration. Unit tests ensure that each uniquepath
of a business process performs accurately to the documented specifications and contains
clearly defined inputs and expected results.
5.2.2 Integration testing:

Integration tests are designed to test integrated software components to determine

if they actually run as one program. Testing is event driven and is more concerned with
the basic outcome of screens or fields. Integration tests demonstrate that although the
components were individually satisfaction, as shown by successfully unit testing, the
combination of components is correct and consistent. Integration testing is specifically
aimed at exposing the problems that arise from the combination of components.
5.2.3 Functional test:

Functional tests provide systematic demonstrations that functions tested are

available as specified by the business and technical requirements, system documentation,
and user manuals.
Department of CSE[AI&ML]
 17
Library management using python

Valid input Identified classes of valid input

must be
accepted.
Invalid input Identified classes of invalid input
must be
rejected.
Functions Identified functions must be
exercised.
Output Identified classes of operation
outputs must
be exercised.
Procedures/systems Interface
systems/proce
dures must be
invoked.

Organization and preparation of functional tests is focused on requirements, key

functions, or special test cases. In addition, systematic coverage pertaining to identify
Business process flows; data fields, predefined processes, and successive processes must
be considered for testing. Before functionaltesting is complete, additional tests are
identified and the effective value of current tests is determined.

5.3 System Test:

System testing ensures that the entire integrated software system meets
requirements. It tests a configuration to ensure known and predictable results. An example
of system testing is the configuration-oriented system integration test. System testing is
based on process descriptions and flows, emphasizing pre-driven process links and
integration points.
5.4 Acceptance Testing:

User Acceptance Testing is a critical phase of any project and requires significant
participation by the end user. It also ensures that the system meets the functional

Department of CSE[AI&ML]
 18
Library management using python

requirements.

5.5 White Box Testing:

White Box Testing is a testing in which in which the software tester has knowledge
of the inner workings, structure and language of the software, or at least its purpose. It is
purpose. It is used to test areas that cannot be reached from a black box level.

5.6 Black Box Testing:

Black Box Testing is testing the software without any knowledge of the inner
workings, structure or language of the module being tested. Black box tests, as most other
kinds of tests, must be written from a definitive source document, such as specification or
requirements document, such as specification or requirements document. It is a testing in
which the software under test is outputs withoutconsidering how the software works.

Features to be tested:
 Verify that the entries are of the correct format.
 No duplicate entries should be allowed.
 All links should take the user to the correct page.

Test objectives:
• All field entries must work properly.
• Pages must be activated from the identified link.
• The entry screen, messages and responses must not be delayed.

Test Results:
All the test cases mentioned above passed successfully. No defects encountered.

Department of CSE[AI&ML]
 19
Library management using python

[Link]
6.1 Login Page

6.2 Output page

Department of CSE[AI&ML]
 20
Library management using python

[Link] AND FUTURE SCOPE

Conclusion
In conclusion, from proper analysis and assessment of the designed system it can be
safely concluded that the system is an efficient, usable, and reliable Library Management
System. Itis workingproperly and adequately meets the minimum expectations that were for it
initially. The new system is expected to give benefits to the users and staff in terms of efficiency
in the usage of library system.
Creating a library management system using Python presents an efficient and organized
way to handle various library operations. The system allows for easy cataloging, tracking, and
managing of books, borrowers, and transactions. This project aids librarians in streamlining
tasks, enhancing user experience, and maintaining accurate records.
Through the implementation of Python, developers can harness its flexibility and
extensive libraries, such as SQL Alchemy for database management, Flask or Django for web
development, and Tkinter or PyQt for creating a user-friendly interface. Leveraging these tools
enables the system to perform functions like adding new books, managing inventory, issuing
and returning books, generatingreports, and handling user accounts efficiently.

Future scope:
Python offers a robust ecosystem of libraries and frameworks that can significantly
enhance thecapabilities and scalability of a library management system. Here are some future
scope areas where Python can be employed:
1. Database Integration: Implementing database systems like MySQL, PostgreSQL, or
SQLite using libraries like SQLAlchemy or Django ORM for efficient data storage, retrieval,
and management of books, users, transactions, etc.
2. GUI Development: Utilize Python libraries such as Tkinter, PyQt, or Kivy to create a more
user- friendly and visually appealing graphical interface for the library management system.
3. Web Application Development: Employ web frameworks like Flask or Django to create a
web-based library management system. This allows users to access the library system from any
browser, enabling features like online catalog browsing, user account management, and more.

Department of CSE[AI&ML]
 21
Library management using python

REFERENCES

1. "Python Crash Course" by Eric Matthes: Covers Python fundamentals and can serve as a
good startingpoint for beginners.
2. "Flask Web Development" by Miguel Grinberg: Focuses on building web applications
with Flask, which can be beneficial for creating web-based library management systems.
3. "Django for Beginners" by William S. Vincent: Provides a comprehensive introduction
to Django, suitable for beginners interested in building web applications, including library
management systems. [Link]: Platforms like Coursera offer courses on Python
programming, web development with Flask/Django, and database management that can be
valuable for creating a library management system. [Link]: Offers various courses on Python,
web development, and specific library integrations that can help in building a library
management system
6. Flask Documentation: The official Flask documentation provides a comprehensive guide
to creatingweb applications using Flask.
7. Django Documentation: The official Django documentation offers detailed information
on buildingweb applications using Django.
8. SQLAlchemy Documentation: For database management, SQLAlchemy's documentation
offers insights into using this powerful ORM library with Python.
9. The Flask Mega-Tutorial by Miguel Grinberg: A comprehensive guide that covers various
aspects ofweb development with Flask, including user authentication and database integration.
10. Reddit communities such as r/learnpython, r/flask, and r/django: Engage in discussions,
seek advice, and learn from the experiences of other developers.
11. python-library-management · GitHub Topics · GitHub.
12. Library Management System Project in Python with Source Code - Python Geeks.

Department of CSE[AI&ML]