Scribd
Upload
20 views22 pages

Library Management System in Python & MySQL

This document describes a library management system built using Python and MySQL. It includes details on the tables used to store book, issue, and return data. It also provides the source code and functions for connecting to the database, adding/retrieving books, issuing/returning books, and updating book counts.

Uploaded by

Prad Hap
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views22 pages

Library Management System in Python & MySQL

This document describes a library management system built using Python and MySQL. It includes details on the tables used to store book, issue, and return data. It also provides the source code and functions for connecting to the database, adding/retrieving books, issuing/returning books, and updating book counts.

Uploaded by

Prad Hap
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

lOMoARcPSD|42400624

Library Management System Using Python AND MY SQL

Computer science (Gandhi Institute for Technological Advancement)

Scan to open on Studocu

Studocu is not sponsored or endorsed by any college or university


Downloaded by Prad Hap (phap79234@[Link])
lOMoARcPSD|42400624

LIBRARY
MANAGEMENT
SYSTEM
Using Python and mySQL

GANDHI INSTITUTE OF TECHNOLOGICAL ADVANCEMENT (GITA),


BHUBANESWAR, ODISHA-752054, INDIA

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

LIBRARY MANAGEMENT SYSTEM USING


PYTHON AND MY SQL

Project ID: xxxxxx


A Mini Project Report
Submit for fulfilment of the requirements for the
Degree of Bachelor of Technology
Under GITA Autonomous College, Bhubaneswar

Submitted By

Susil Kumar Sahu


Roll No: #CSIT2105058
Prabhupada Nayak
Roll No: #CSIT2105035

May- 2023

Under the guidance of

Dr. Parimal Kumar Giri

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

GANDHI INSTITUTE OF TECHNOLOGICAL ADVANCEMENT


(GITA), BHUBANESWAR, ODISHA-752054, INDIA

CERTIFICATE
This is to certify that the project work entitled ‘LIBRARY MANAGEMENT SYSTEM
USING PYTHON AND MY SQL xxxxxx’ is a bonafide work being SUSIL KUMAR
SAHU and PRABHUPADA NAYAK bearing Registration No. #2101287387 and
Registration No. #2101287366 of B. Tech CSIT branch.

This project report is submitted in partial fulfillment for the requirement of the [Link] degree
under Gandhi Institute of Technological Advancement (GITA), Bhubaneswar, Odisha.

Project Coordinator Date Project Guide

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

Acknowledgem
ent
I would like to take this opportunity to thank all those individuals whose invaluable
contribution in a direct or indirect manner has gone into the making of this mini project a
tremendous learning experience for me.

It is my proud privilege to epitomize my deepest sense of gratitude and indebtedness to my


faculty guide, Prof. / Dr. xyz for his valuable guidance, keen and sustained interest, intuitive
ideas and persistent endeavour. His guidance and inspirations enabled me to complete my
report work successfully.

I give my sincere thanks to Prof./Dr. xyz, Project Coordinator and Dr. Parimal Kumar Giri,
HOD CSIT for giving me the opportunity and motivating me to complete the project within
stipulated period of time and providing a helping environment.

I acknowledge with immense pleasure the sustained interest, encouraging attitude and
constant inspiration rendered by Prof. (Dr.) M.K. Roul (Principal), GITA Autonomous.
Their continued drive for better quality in everything that happens at GITA and selfless
inspiration has always helped us to move ahead.

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

Susil Kumar Sahu


Prabhupada Nayak

PROJECT ON
LIBRARY MANAGEMENT
SYSTEM
2021-25

Group members:

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

• Susil Kumar
Sahu
•Pra
bhupada Nayak

INDEX
Particulars Page
[Link].
1 06
Project Analysis

2 Functions and modules 07

3 Detailed Description 10
4 Source Code 11
5 Outputs And Tables 15
6 Bibliography 18
remarks 19
7

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

PROJECT ANALYSIS
Our application program is specially
designed for the public library named
"READING COMMUNITY."

They lend books to readers who have subscribed


with the library.

We have tried to maximise the efficiency and strived for customer and
user ease as well as satisfaction.

We have thoroughly examined the needs of the library and after the
analysis, we have constructed the program.

We have used PYTHON and MYSQL as our platform

to carry out this task.

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

functions and modules

modules:

import [Link]:

By importing this package,we are able to establish the


connection between SQL and PYTHON.

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

FUNCTIONS:

connect():
This function establishes connection between Python
andMySQL.

cursor():
It is a special control structure that facilitates the row-by- row
processing of records in the result set.
The Syntax is:
<cursor object>=<connection object>.cursor()

execute():
This function is used to execute the sql query and retrieve
records using python.
The syntax is:
<cursor object>.execute(<sql query string>)

def():
A function is a block of code which only runs when it is
called.

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

fetchall():
This function will return all the rows from the result set in the
form of a tuple containing the records.
fetchone():
This Function will return one row from the result set in the
form of a tuple containing the records.
commit():
This function provides changes in the database physically.

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

DETAILED
DESCRIPTION

*) Our Project has 3 MySQL tables. These are:-


1.) Books
2.) Issue
3.) Submit
1) The table Books contain the following columns:
a) bname
b) bcode
c) total
d) subject
2.) The table Issue contain the following columns:
a.) name
b.) regno
c.) bcode
d.) issue_date
3.) The table Return contain the following columns:
a.) name
b.) regno
c.) bcode
d.) submit_date

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

source code
for mysql:

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

Source code
For python:
import [Link] as a
con=[Link](host="localhost",user="root",passwd="Susil@1@2@3",database="libr
ary1")

def addbook():
bn=input("enter the book name : ")
c=input("enter the book code : ")
t=input("total book : ")
s=input("enter subject : ")
data=(bn,c,t,s)
sql='insert into books values(%s,%s,%s,%s)'
c=[Link]()
[Link](sql,data)
[Link]()
print(">---------------------------------------------------------------<")
print("DATA ENTERED SUCCESSFULLY")
main()
def issueb():
n=input("enter the name : ")
r=input("enter the reg no : ")
co=input("enter book code : ")
r=input("enter the reg no : ")
d=input("enter date : ")
a="insert into issue values(%s,%s,%s,%s)"
data=(n,co,r,d)
c=[Link]()
[Link](a,data)
[Link]()
print(">---------------------------------------------------------------<")
print("Book Issued To :",n)
bookup(co,-1)
def submitb():
n=input("enter the name : ")
r=input("enter the reg no : ")
co=input("enter book code : ")
d=input("enter date : ")
data=(n,r,co,d)
a='insert into submit values(%s,%s,%s,%s)'
c=[Link]()
[Link](a,data)
[Link]()

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

print(">---------------------------------------------------------------<")
print("Book submitted from :",n)
bookup(co,-1)
def bookup(co,u):
a="select TOTAL from books where BCODE = %s"
data=(co,)
c=[Link]()
[Link](a,data)
myresult=[Link]()
t=myresult[0] + u
sql="update books set TOTAL = %s where BCODE =%s"
d=(t,co)
[Link](sql,d)
[Link]()
main()
def dbook():
ac=input("enter book code")
a="delete from books where BCODE=%s"
data=(ac,)
c=[Link]()
[Link](a,data)
[Link]()
main()
def dispbook():
a="select* from books"
c=[Link]()
[Link](a)
myresult=[Link]()
for i in myresult:
print("book name : ",i[0])
print("book code : ",i[1])
print("total : ",i[2])
print(">---------------------------------------------------------<")
main()
def main():
print("""

LIBRARY MANAGER

[Link] BOOK
[Link] BOOK
[Link] BOOK
[Link] BOOK
[Link] BOOKS
""")

choice=int(input("Enter Task No : "))

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

print(">----------------------------------------------------------------
<")
if(choice==1):
addbook()
elif(choice==2):
issueb()
elif(choice==3):
submitb()
elif(choice==4):
dbook()
elif(choice==5):
dispbook()
else:
print("wrong choice.........")
main()
def pswd():
ps=input("enter password : ")
if(ps=="Susil@1@2@3"):
main()
else:
print("Wrong password")
pswd()
pswd()

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

outputs and tables


Outputs:
1.)Add a book:

2.)issue a book:

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

3.)Submit the book:

4.)delete the book:

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

5.)display the books:

TABLES:
1.)select * from books:

2.)select * from issue:

3.)select * from submit:

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

BIBLIOGRAPHY
 To develop this project many
references are used
[Link]://[Link]
[Link]://[Link]

Downloaded by Prad Hap (phap79234@[Link])


lOMoARcPSD|42400624

Remark

Downloaded by Prad Hap (phap79234@[Link])

Common questions

Powered by AI

The user interface of the application, as indicated by the functions available (such as addbook(), issueb(), submitb(), dbook(), and dispbook()), is designed to be simple and functional. By presenting direct commands in the main() function to add, issue, submit, delete, and display books, the interface provides basic library management operations competently. However, the interface lacks advanced user-friendly features like GUI-based interactions, which might limit usability for non-technical users .

The Library Management System uses the mysql.connector module in Python to establish a connection with the MySQL database. Functions like connect(), cursor(), execute(), fetchall(), fetchone(), and commit() are employed for various database operations such as establishing connections, executing SQL queries, retrieving results, and committing changes to the database .

The system ensures data integrity during book transactions by using specific functions to update and maintain accurate records. For example, the bookup() function adjusts the total number of books available when a book is issued or returned, ensuring consistent updating of book counts. This function is executed after each transaction, whether a book is issued or submitted, to immediately reflect changes in the database .

The primary objective of the Library Management System project is to streamline the book lending process for a public library named 'READING COMMUNITY' by maximizing efficiency and enhancing customer and user satisfaction. The project utilizes PYTHON and MySQL to meet the library's specific needs .

Potential improvements could include developing a graphical user interface (GUI) to enhance accessibility and ease of use for non-technical users, implementing a more robust authentication method rather than a single hardcoded password to improve security, and integrating an online portal for remote access. Additionally, expanding the system's functionalities to track overdue books and notifications could enhance the library's operational efficiency .

The main MySQL tables used in the Library Management System are 'Books', 'Issue', and 'Submit'. The 'Books' table contains columns for book name (bname), book code (bcode), total number of books (total), and subject. The 'Issue' table records details about issued books, such as the name, registration number, book code, and issue date. The 'Submit' table logs returned books with columns for the submitter's name, registration number, book code, and submission date .

The 'main()' function serves as the central control mechanism for user inputs and navigates them through the primary operations of the system. It provides a menu with options to add, issue, submit, delete, and display books, and manages the flow of control by calling the corresponding functions based on user choices. This modular approach helps to organize and execute specific tasks efficiently .

The Library Management System employs a simple password protection measure to secure access to its main functionalities. The pswd() function prompts users to enter a password ('Susil@1@2@3') before they can access the main() menu of operations. This measure, although basic, prevents unauthorized access to the application's features .

Challenges in maintaining the database include data consistency across multiple transactions, handling simultaneous access by multiple users, and managing potential data corruption. Addressing these challenges can involve implementing database normalization to reduce redundancy, using transactions and locks to maintain data consistency, and employing regular backups combined with audits to detect and correct data anomalies .

The use of procedural programming, as seen in this project, often results in a straightforward and linear code structure that is easy to understand and implement for small-scale applications. However, this can limit the scalability and flexibility of the system as procedural code can become cumbersome with more complex functionalities and larger data volumes. Using object-oriented programming could provide a more modular and adaptable framework, allowing for easier maintenance and extension of the system .

You might also like