SHREE VALLABH ASHRAM’S M.G.M.
AMIN & V.N. SAVANI SCHOOL KILLA
PARDI-396195
INFORMATICS
PRACTICES
Page.1
NAME: DARSHIT RAJESHBHAI VAGHASIYA
CLASS: XII-C
ROLL NO.: 04
EXAM ROLL NO.:
ACADEMIC YEAR: 2020-21
SHREE VALLABH ASHRAM’S M.G.M. AMIN
& V.N. SAVANI SCHOOL
CERTIFICATE
This is to certify that Master Darshit
Rajeshbhai Vaghasiya of class XII-C has
successfully completed the Informatics
Practices project on the topic Library
Page.2
Management under the guidance of
Alauddin Sayed sir during the academic
year 2020-21.
____________________
____________________
INTERNAL EXAMINER PRINCIPAL
____________________
____________________ DATE
EXTERNAL EXAMINER
Acknowledgement
I would like to express my special thanks of gratitude to
my teacher Mr.Alauddin Saiyad sir as well as our
principal Mr. Rajendra Prasad Maurya sir who gave me
the golden opportunity to do this project of Informatics
Practices, which also helped me in doing a lot of research
and I came to know new things about it. Without their
help, guidance and support it would have been
impossible to complete this project.
Secondly, I would also like to thank my parents and
friends who helped me a lot in finishing this project
Page.3
within limited time. I am making this project not only for
marks but also to increase my knowledge.
Once again thanks to all who helped me in doing this
project.
PROJECT ON
LIBRARY MANAGEMENT
2020-21
Group Members:
• Darshit Vaghasiya
• Sunny Soni
Page.4
• Vatsal Gandhi
INDEX
Sr.no Pag
Particulars
. e
1 Project Analysis 06
Functions and
2 07
Modules
Detailed
3 10
Description
4 Source Code 11
Outputs and
5 17
Tables
6 Bibliography 28
7 Remarks 29
Page.5
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.
Page.6
FUNCTIONS AND
MODULES
Modules:
import mysql.connector:
By importing this package, we are able to establish the
connection between SQL and Python.
FUNCTIONS:
connect():
This function establishes connection between Python and
MySQL
cursor():
Page.7
It is a special control structure that facilitates the row-
byrow 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.
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():
Page.8
This function provides changes in the database physically.
DETAILED DESCRIPTION
❖ ) Our Project has 3 MySQL tables. These are: -
1.) Books
2.) Issue
3.) Return
1) The table Books contain the following columns:
a) bname
b) author
c) bcode
d) total
e) subject
2.) The table Issue contain the following columns:
a.) name
b.) regno
c.) bcode
Page.9
d.) issue_date
3.) The table Return contain the following columns:
a.) name
b.) regno
c.) bcode
d.) return_date
SOURCE CODE
For MySQL:
create database library_app;
use library_app; create table
books (bname varchar(50),
author varchar(50), bcode
varchar(50), total int(50),
subject varchar(50));
create table issue (name
varchar(50), regno
varchar(50), bcode
Page.10
int(50), issue_date
varchar(50));
create table return
(name varchar(50), regno
varchar(50), bcode
int(50), return_date
varchar(50));
For Python:
import mysql.connector as a
con=a.connect(host='localhost',user='root',passwd='9586',data
base='library_app')
def addbook(): bn=input("Enter
Book Name: ") ba=input("Enter
Author's Name: ")
c=int(input("Enter Book Code: "))
t=int(input("Total Books: "))
s=input("Enter Subject: ")
data=(bn,ba,c,t,s)
sql='insert into books values(%s,%s,%s,%s,%s);'
c=con.cursor()
c.execute(sql,data)
con.commit()
print("\n\n\n\nBook Added Successfully..........\n\n\n\n")
wait = input('\n\n\nPress enter to continue.....\n\n\n\n\n\n')
main()
def issueb(): n=input("Enter
Student Name: ")
Page.11
r=int(input("Enter Reg No.: "))
co=int(input("Enter Book Code: "))
d=input("Enter Date: ")
a="insert into issue values(%s,%s,%s,%s);"
data=(n,r,co,d) c=con.cursor()
c.execute(a,data)
con.commit()
print("\n\n\n\nBook issued successfully to: ",n)
wait = input('\n\n\nPress enter to continue.....\n\n\n\n\n\n')
bookup(co,-1)
main()
def returnb(): n=input("Enter
Student Name: ")
r=int(input("Enter Reg No.: "))
co=int(input("Enter Book Code: "))
d=input("Enter Date: ")
a="insert into return_ values(%s,%s,%s,%s);"
data=(n,r,co,d) c=con.cursor()
c.execute(a,data)
con.commit()
print("Book returned by: ",n)
wait = input('\n\n\nPress enter to continue.....\n\n\n\n\n\n')
bookup(co,1) main()
def bookup(co,u): a="select total from books
where bcode=%s;" data=(co,)
c=con.cursor()
c.execute(a,data)
myresult=c.fetchone()
t=myresult[0]+u
sql="update books set total=%s where bcode=%s;"
d=(t,co)
Page.12
c.execute(sql,d)
con.commit()
wait = input('\n\n\nPress enter to continue.....\n\n\n\n\n\n')
main()
def dbook(): ac=int(input("Enter
Book Code: "))
a="delete from books where bcode=%s;"
data=(ac,) c=con.cursor()
c.execute(a,data)
con.commit()
print("Book deleted successfully")
wait = input('\n\n\nPress enter to
continue.....\n\n\n\n\n\n\n\n\n\n\n\n')
main()
def dispbook(): a="select *
from books;"
c=con.cursor() c.execute(a)
myresult=c.fetchall() for i
in myresult: print("Book
name: ",i[0])
print("Author: ",i[1])
print("Book code: ",i[2])
print("Total:",i[3])
print("Subject:",i[4])
print('\n\n')
wait = input('\n\n\nPress enter to
continue.....\n\n\n\n\n\n\n\n\n\n\n\n')
main()
Page.13
def report_issued_books():
a="select * from issue;"
c=con.cursor()
c.execute(a)
myresult=c.fetchall() for
i in myresult:
print(myresult)
wait = input('\n\n\nPress enter to
continue.....\n\n\n\n\n\n\n\n')
main()
def report_return_books():
a="select * from return_;"
c=con.cursor()
c.execute(a)
myresult=c.fetchall() for i
in myresult:
print(myresult)
wait = input('\n\n\nPress enter to
continue.....\n\n\n\n\n\n\n\n\n\n\n\n')
main()
def main():
print("""
LIBRARY MANAGEMENT APPLICATION
_________________________________________________
1. ADD BOOK
2. ISSUE OF BOOK
Page.14
3. RETURN OF BOOK
4. DELETE BOOK
5. DISPLAY BOOKS
6. REPORT MENU
7. EXIT PROGRAM
""")
choice=input("Enter Task No:......")
print('\n\n\n\n\n\n\n')
if(choice=='1'): addbook()
elif(choice=='2'):
issueb()
elif(choice=='3'):
returnb()
elif(choice=='4'):
dbook()
elif(choice=='5'):
dispbook() elif(choice=='6'):
print(''' R E P O R T M E N U
______________________
1. ISSUED BOOKS
2. RETURNED BOOKS
3. GO BACK TO MAIN MENU
\n\n\n
''')
choice=input("Enter Task No:......")
print('\n\n\n\n\n\n\n') if
choice=='1':
report_issued_books()
elif choice=='2':
report_return_books()
elif choice=='3':
Page.15
main()
else:
print("Please try again........\n\n\n\n\n\n\n\n\n")
main() elif(choice=='7'):
print('\n\n\n\n\n\n\n\n\n\n\n\nThank you and have a great day
ahead...............\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n') else:
print("Please try again........\n\n\n\n\n\n\n\n\n\n\n\n")
main()
main()
OUTPUTS AND
TABLES
Page.16
➢ OUTPUTS:
1.) Add a Book:
Page.17
2.) Issue a Book:
3.) Return of Book:
Page.18
4.) Delete a Book:
Page.19
5.) Display Books:
Page.20
6.) Report Menu:
Page.21
Page.22
7.) Exit Program:
Page.23
➢ TABLES:
1.) Select * from Books:
Page.24
2.) Select * from Issue:
Page.25
3.) Select * from Return_
Page.26
BIBLIOGRAPHY
Page.27
❖ To develop this project many references
were used:
1. INFORMATICS PRACTICES Class XII: PREETI ARORA
2. https://www.google.com
REMARKS
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
Page.28
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
_____________________________________
___________
Page.29
