KENDRIYA VIDYALAYA SHALIMAR BAGH, NEW DELHI
PROJECT REPORT
ON
Library Book Issuance and Recollecting
Management System
Session -2021-22
1
In the partial fulfillment of All India Senior School Certificate
Examination for the session 2021-22 conducted by Central
Board of Secondary Education.
Submitted by :-Anjali Ojha Submitted to :- Ms. Priyanka
Class – XII-A PGT Computer Science
Roll No- KV Shalimar Bagh
2
CERTIFICATE
This is to certify that ANJALI OJHA Roll No – has successfully
completed the project Work entitled Library Book Issuance and Recollecting
Management System in the subject Computer Science (083) laid down in the
regulations of CBSE for the purpose of Practical Examination in Class XII
to be held in KV Shalimar bagh on 12/11/2021.
(mrs. Priyanka upmanu )
PGT Computer Science
Master IC
Examiner:
Name: _______________
Signature:
3
S.No DESCRIPTION
01 ACKNOWLEDGEMENT
02 INTRODUCTION
03 OBJECTIVES OF THE PROJECT
04 PROPOSED SYSTEM
05 SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)
06 FLOW CHART
07 SOURCE CODE
08 OUTPUT
09 HARDWARE AND SOFTWARE REQUIREMENTS
10 BIBLIOGRAPHY
4
ACKNOWLEDGEMENT
Apart from the efforts of me, the success of any project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express my gratitude
to the people who have been instrumental in the successful completion of this project.
I express deep sense of gratitude to almighty God for giving me strength for the successful
completion of the project.
I express my heartfelt gratitude to my parents for constant encouragement while carrying out
this project.
I gratefully acknowledge the contribution of the individuals who contributed in bringing this
project up to this level, who continues to look after me despite my flaws,
I express my deep sense of gratitude to the luminary The Principal, KV Shalimar Bagh who
has been continuously motivating their helping hand to us.
I express my sincere thanks to the academician The Vice Principal, KV Shalimar Bagh, for
constant encouragement and the guidance provided during this project
I am overwhelmed to express my thanks to The Administrative Officer for providing me an
infrastructure and moral support while carrying out this project in the school.
My sincere thanks to Mrs. Priyanka Upmanu, Master In-charge, A guide, Mentor all the above
a friend who critically reviewed my project and helped in solving each and every problem,
occurred during implementation of the project
The guidance and support received from all the members who contributed and who are
contributing to this project, was vital for the success of the project. I am grateful for their
constant support and help.
5
PROJECT ON LIBRARY BOOK ISSUANCE AND
RECOLLECTING MANAGEMENT SYSTEM
INTRODUCTION
The project is based on Library Book Issuance and Recollecting Management
System.
This project is developed on python by interfacing it with MYSQL.
This system can insert records, update records, delete records, display
records, and generate records, i.e. of a particular person we want.
Name of databases: Project
Name of table: Library
OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the programming knowledge into a
real- world situation/problem and exposed the students how programming skills helps in
developing a good software.
1. Write programs utilizing modern software tools.
2. Apply object oriented programming principles effectively when developing
small to medium sized projects.
3. Write effective procedural code to solve small to medium sized problems.
4. Students will demonstrate a breadth of knowledge in computer science, as
exemplified in the areas of systems, theory and software development.
5. Students will demonstrate ability to conduct a research or applied Computer
Science project, requiring writing and presentation skills which exemplify scholarly style
in computer science.
6
PROPOSED SYSTEM
Today one cannot afford to rely on the fallible human beings of be really
wants to stand against today’s merciless competition where not to wise
saying “to err is human” no longer valid, it’s out-dated to rationalize your
mistake. So, to keep pace with time, to bring about the best result without
malfunctioning and greater efficiency so to replace the unending heaps of
flies with a much sophisticated hard disk of the computer.
One has to use the data management software. Software has been an ascent in
atomization various organizations. Many software products working are now
in markets, which have helped in making the organizations work easier and
efficiently. Data management initially had to maintain a lot of ledgers and a
lot of paperwork has to be done but now software production this
organization has made their work faster and easier. Now only this software
has to be loaded on the computer and work can be done.
This prevents a lot of time and money. The work becomes fully automated
and any information regarding the organization can be obtained by clicking
the button. Moreover, now it’s an age of computers of and automating such an
organization gives the better look.
7
SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)
The systems development life cycle is a project management technique that
divides complex projects into smaller, more easily managements or phases.
Segmenting projects allows managers to verify the successful completion of
project phases before allocating resources to subsequent phases.
Software development projects typically include initiation, planning, design,
development, testing, implementation, and maintenance phases. However,
the phases may be divided differently depending on the organization
involved.
For example, initial project activities might be designated as request,
requirements-definition, and planning phases, or initiation, concept-
development, and planning phases. End users of the system under
development should be involved in reviewing the output of each phase to
ensure the system is being built to deliver the needed functionality.
8
PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE
FLOW CHART
4.THEN THE DATA 1.COMMANDED
WILL BE SEND PROGRAM WILL BE
EXECUTED IN PYTHON
IDLE .
3.THE REQUIRED 2.AS THE PYTHON
DATA WILL BE TAKEN AND MYSQL ARE
FROM THE CONNECTED THE
DATABASE. COMMAND WILL BE
SENT TO MYSQL.
9
Source code
import mysql.connector
b=input("Enter name of your database: ")
mydb=mysql.connector.connect(host='localhost',user='root',passwd='root')
mycursor = mydb.cursor()
sql="CREATE DATABASE if not exists %s" % (db,)
mycursor.execute(sql)
print("Database created Successfully..")
mycursor=mydb.cursor()
mycursor.execute("Use "+db)
TableName=input("Name of Table to be created:")
query="Create table if not exists"+TableName+"\
(isbncode int ,primary key,\
author varchar(15) ,not null,\
bookname varchar(25),\
issuername varchar(25),\
address varchar(30),\
phone int,\
issuedate date,\
duedate date,\)"
print("Table "+TableName+" created successfully....")
def add():
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root",database="proje
ct")
10
mycur=mydb.cursor( )
ch='y';
while ch=='y' or ch=='Y':
isbncode=int(input("\nEnter The Isbn no: "))
author =input("Enter The Author name: ")
bookname=input("Enter The Book Name: ")
issuername=input("Enter The issuername: ")
address=input("Enter The Adrress: ")
phone=int(input("Enter The Phone: "))
issuedate=input("Enter Issue Date YYYY-MM-DD ")
duedate=input("Enter Return Date YYYY-MM-DD ")
str="INSERT INTO library VALUES({},'{}','{}','{}','{}',{},'{}','{}')"
query=(str.format(isbncode,author,bookname,issuername,address,phone,issuedate, duedate))
mycur.execute(query)
mydb.commit()
print("\nRocord inserted\n")
ch=input("Want to Add more records(y/n): ")
mydb.close()
def search():
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root",database="project")
mycur=mydb.cursor( )
isbncode=int(input("\nEnter The Isbn no: "))
str="Select * from library where isbncode={}"
query=str.format(isbncode)
print('******************************************************************')
mycur.execute(query)
myrec=mycur.fetchall()
11
for x in myrec:
isbncode=x[0]
author=x[1]
bookname=x[2]
issuername=x[3]
address=x[4]
phone=x[5]
issuedate=x[6]
duedate=x[7]
print(isbncode," ",author," ",bookname," ",issuername," ",address," ",phone," ",issuedate," ",
duedate)
mydb.close()
def display():
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root", database="project")
mycur=mydb.cursor( )
mycur.execute("Select * from library")
print('****************************************************************************')
myrec=mycur.fetchall()
for x in myrec:
isbncode=x[0]
author=x[1]
bookname=x[2]
issuername=x[3]
address=x[4]
phone=x[5]
issuedate=x[6]
duedate=x[7]
12
print(isbncode," ",author," ",bookname," ",issuername," ",address," ",phone," ",issuedate," ",
duedate)
mydb.close()
isbncode=int(input("\nEnter The Isbncode you want to Update: "))
author =input( “ Enter The Author name: ")
bookname=input("Enter The Book Name: ")
issuername=input("Enter The issuername: ")
address=input("Enter The Adrress: ")
phone=int(input("Enter The Phone: "))
issuedate=input("Enter Issue Date YYYY-MM-DD ")
duedate=input("Enter Return Date YYYY-MM-DD ")
str="Update library set author='{}', bookname='{}', issuername='{}', address='{}', phone={},
issuedate='{}', duedate='{}' where isbncode={}"
query=str.format(author,bookname,issuername,address,phone,issuedate, duedate,isbncode)
mycur.execute(query)
mydb.commit()
mycur=mydb.cursor( )
print('****************************************************************************')
print('After Updation')
mycur.execute("Select * from library")
myrec=mycur.fetchall()
for x in myrec:
isbncode=x[0]
author=x[1]
bookname=x[2]
issuername=x[3]
address=x[4]
13
phone=x[5]
issuedate=x[6]
duedate=x[7]
print(isbncode," ",author," ",bookname," ",issuername," ",address," ",phone," ",issuedate," ",
duedate)
mydb.close()
def delete():
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root",database="project")
mycur=mydb.cursor( )
mycur.execute("Select * from library")
print('**************************************************************************')
myrec=mycur.fetchall()
for x in myrec:
isbncode=x[0]
author=x[1]
bookname=x[2]
issuername=x[3]
address=x[4]
phone=x[5]
issuedate=x[6]
duedate=x[7]
print(isbncode," ",author," ",bookname," ",issuername," ",address,"",phone," ",issuedate," ",
duedate)
isbncode=int(input("\nEnter The Isbn no: "))
str="Delete from library where isbncode={}"
query=str.format(isbncode)
mycur.execute(query)
14
mydb.commit()
print("record deleted")
print ('************************************************************************')
print('After Deletion ')
mycur=mydb.cursor( )
mycur.execute("Select * from library")
print('************************************************************************')
myrec=mycur.fetchall()
for x in myrec:
isbncode=x[0]
author=x[1]
bookname=x[2]
issuername=x[3]
address=x[4]
phone=x[5]
issuedate=x[6]
duedate=x[7]
print(isbncode," ",author," ",bookname," ",issuername," ",address," ",phone," ",issuedate," ",
duedate)
mydb.close()
def generate():
amt=1
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root",database="project")
mycur=mydb.cursor( )
isbncode=int(input("\nEnter The Isbn no: "))
str="selectisbncode,bookname,issuername,address,phone,issuedate,duedate, curdate(),
dayofyear(curdate()) –dayofyear(duedate)from library where isbncode={}"
15
query=str.format(isbncode)
mycur.execute(query)
myrec=mycur.fetchall()
for x in myrec:
isbncode=x[0]
bookname=x[1]
issuername=x[2]
address=x[3]
phone=x[4]
issuedate=x[5]
duedate=x[6]
Today=x[7]
a=x[8]
print('******************************************************')
print("...............WELCOME TO UNIQUE LIBRARY...............")
print("...............470, LABOUR CHOWK.......................")
print("...............BURARI, DELHI-84.........................")
print('*******************************************************************')
print('Name ',issuername)
print('Phone ',phone)
print('******************************************************************')
print('Issue Date',issuedate)
16
print('Return Date',duedate)
print("curdate",curdate)
if a>0:
amt=a*10
print('*********************************************************************')
print("Late Fine Rs -10per day \n")
print("Your bill is Rs. \t",amt)
else:
print("Your bill is Rs. \t",amt)
mydb.close()
print('*******************************************************')
print('<====== WELCOME TO UNIQUE LIBRARY ======>')
print('************************************************************')
ch='y'
while ch=='y' or ch=='Y':
print("CHOICES")
print("1.To ADD New Record")
print("2.To Search a Record")
print("3.To View all the Record")
print("4.To Update the Record")
print("5.To Delete the Record")
print("6.To Generate the Report\n")
print('*******************************************************')
17
if ch==1:
add()
elif ch==2:
search()
elif ch==3:
display()
elif ch==4:
edit()
elif ch==5:
delete()
elif ch==6:
generate()
print('**************************************************************')
ch=input("Want to See Main Menu(y/n): ")
18
output
19
HARDWARE AND SOFTWARE REQUIREMENTS
I.OPERATING SYSTEM : WINDOWS 10 AND ABOVE
II. PROCESSOR : PENTIUM(ANY) OR AMD
ATHALON (3800+- 4200+ DUALCORE)
III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIAK8M800+8237R PLUS CHIPSET FOR AMD ATHALON
IV. RAM : 512MB+
V. Hard disk : SATA 40 GB OR ABOVE
VI. CD/DVD r/w multi drive combo: (If back up required)
VII. FLOPPY DRIVE 1.44 MB : (If Backup required)
VIII. MONITOR 14.1 or 15 -17 inch
IX. Key board and mouse
X. Printer : (if print is required – [Hard copy])
SOFTWARE REQUIREMENTS
I. Windows OS
II. Python
III. mysql
LIMITATION OF THE PROJECT
• It does not have a proper GUI (graphical user interface is a form of user
interface that allows users to interact with electronic devices through graphical
icons and audio indicator such as primary notation, instead of text-based user
interfaces, typed command labels or text navigation.)
20
• Requires a proper knowledge to run the project.
• Cannot be used online.
CONCLUSIONS
“Library issuance and recollecting management system” has been
made to reduce the annual work and with the help of the project every
work is being processed in accurate manner.
Fine and return date is being calculated itself by the computer.
BIBLIOGRAPHY
1. Computer science With Python - Class XI& XII By: Sumita Arora
2. Computer science With Python - Class XI& XII By: Preeti Arora
3. Website: https://www.w3resource.com
**************************
21
