Mini Project Title: Library Management System Roll No.: 1) 2) 3) 4) 20102B0056 20102A0018 20102B0022 20102A0034 Name: 1) 2) 3) 4) Sahil Sawant Shubham Shelatalar Prem Patel Altamash Khan Subject: Database Management System(DBMS) Subject In-charge: Sachin Deshpande Theory: An online bookstore software projects that acts as a central database containing various books in stock along with their title, author and cost. This project is a website that acts as a central book store. This web project is developed using python as the front end and SQL as a back-end. The SQL database stores various book related details. A user visiting the website can see a wide range of books arranged in respective categories. The user may select desired book and view its price. The user may even search for specific books on the website. Once the user selects a book , he then has to fill in a form and the book is booked for the user. User can get to know different kinds of books that they were unaware of by just searching in the system using keywords. This Software is an Online register Substitute for Small Scale Library who keeps track of their Data in Offline Thick Registars. By using this Software they can save money and time by keeping their records Online. The DBMS makes sure that the data is easily accessible and the user can make changes to it efficiently. It is Highly Costomisable and can be customised according to the Library's Data It is a useful management system which help the user to add the name of the book , author of the book, date on which the book is publish and the book serial no in which it is added the library. User can also delete, view, update the existing entry of the book from the database. References: • Python 3.9.6 • MySQL • Imported modules:1. tkinter 2. SQLite3 Program: #Front End from tkinter import * from backend import Database database = Database("books.db") class Window(object): def __init__(self,window): self.window = window self.window.wm_title("Th e Book Store") self.window.configure(bac kground='black') l1 = Label(window, text="Title",fg='white',bg='black') l1.grid(row=0, column=0) l2 = Label(window, text="Author",fg='white',bg='black') l2.grid(row=0, column=2) l3 = Label(window, text="Year",fg='white',bg='black') l3.grid(row=1, column=0) l4 = Label(window, text="Book Code",fg='white',bg='black') l4.grid(row=1, column=2) self.title_text = StringVar() self.e1 = Entry(window, textvariable=self.title_text,bg="grey") self.e1.grid(row=0, column=1) self.author_text = StringVar() self.e2 = Entry(window, textvariable=self.author_text,bg="grey") self.e2.grid(row=0, column=3) self.year_text = StringVar() self.e3 = Entry(window, textvariable=self.year_text,bg="grey") self.e3.grid(row=1, column=1) self.book code_text = StringVar() self.e4= Entry(window, textvariable=self.book code_text,bg="grey") self.e4.grid(row=1, column=3) self.list1 = Listbox(window, height=6, width=35,bg="grey") self.list1.grid(row=2, column=0, rowspan=6, columnspan=2) self.list1.bind('<>', self.get_selected_row) sb1 = Scrollbar(window,) sb1.grid(row=2, column=2, rowspan=6) self.list1.config(yscrollcommand=sb1.set) sb1.config(command=self.list1.yview) b1 = Button(window, text="View all", width=12,fg='white',bg='black',command=self.view_command) b1.grid(row=2, column=3) b2 = Button(window, text="Search entry", width=12,fg='white',bg='black', command=self.search_command) b2.grid(row=3, column=3) b3 = Button(window, text="Add entry", width=12,fg='white',bg='black', command=self.add_command) b3.grid(row=4, column=3) b4 = Button(window, text="Update selected", width=12,fg='white',bg='black', command=self.update_command) b4.grid(row=5, column=3) b5 = Button(window, text="Delete selected", width=12,fg='white',bg='black', command=self.delete_command) b5.grid(row=6, column=3) b6 = Button(window, text="Close", width=12,fg='white',bg='black', command=window.destroy) b6.grid(row=7, column=3) def get_selected_row(self,event): try: index = self.list1.curselection()[0] self.selected_tuple = self.list1.get(index) self.e1.delete(0,END) self.e1.insert(END,self.selected_tuple[1]) self.e2.delete(0, END) self.e2.insert(END,self.selected_tuple[2]) self.e3.delete(0, END) self.e3.insert(END,self.selected_tuple[3]) self.e4.delete(0, END) self.e4.insert(END,self.selected_tuple[4]) except IndexError: pass def view_command(self): self.list1.delete(0, END) for row in database.view(): self.list1.insert(END, row) def search_command(self): self.list1.delete(0, END) for row in database.search(self.title_text.get(), self.author_text.get(), self.year_text.get(), self.book code_text.get()): self.list1.insert(END, row) def add_command(self): database.insert(self.title_text.get(), self.author_text.get(), self.year_text.get(), self. book code _text.get()) self.list1.delete(0, END) self.list1.insert(END, (self.title_text.get(), self.author_text.get(), self.year_text.get(), self. book code _text.get())) def delete_command(self): database.delete(self.selected_tuple[0]) self.view_command() def update_command(self): database.update(self.selected_tuple[0],self.title_text.get(), self.author_text.get(), self.year_text.get(), self. book code _text.get()) self.view_command() window = Tk() Window(window) window.mainloop() #Back End import sqlite3 class Database: def __init__(self,db): self.conn = sqlite3.connect(db) self.cur = self.conn.cursor() self.cur.execute("CREATE TABLE IF NOT EXISTS book (id INTEGER PRIMARY KEY, title TEXT, " "author TEXT, year INTEGER, book code INTEGER)") self.conn.commit() def insert(self,title, author, year, book code): #the NULL parameter is for the auto-incremented id self.cur.execute("INSERT INTO book VALUES(NULL,?,?,?,?)", (title,author,year, book code)) self.conn.commit() def view(self): self.cur.execute("SELECT * FROM book") rows = self.cur.fetchall() return rows def search(self,title="", author="", year="", book code =""): self.cur.execute("SELECT * FROM book WHERE title = ? OR author = ? OR year = ? " "OR book code = ?", (title, author, year, book code)) rows = self.cur.fetchall() #conn.close() return rows def delete(self,id): self.cur.execute("DELETE FROM book WHERE id = ?", (id,)) self.conn.commit() #conn.close() def update(self,id, title, author, year, book code): self.cur.execute("UPDATE book SET title = ?, author = ?, year = ?, book code = ? WHERE id = ?", (title, author, year, book code, id)) self.conn.commit() #destructor-->now we close the connection to our database here def __del__(self): self.conn.close() Output: Conclusion: Various Concept understood and successfully executed the program.