Project 2 Library Book Management System

Hi SIr,

I have developed this application in Spyder and the files would be in py extensions. But still we can run it in Jupyter notebook.

The file Mainwindow.py is the master window for this application, Kindly run this file and the application would display multiple buttons to perform the actions. Each task window has back button to close that particular window.

For adding the book or book borrow(issue) details it has some constrains, if those are not met it will display the warning messgaebox. Kindly enter the details as per the constrains.

Please refer below for some brief uses of the file involved in this application.

Files	Main Packages used	Purpose
Mainwindow	tkinter	mainwindow shows task can be performed by this application
addwindow	tkinter	used to add a book to DB
deletewindow	tkinter	used to delete a book from DB
issuewindow	tkinter	used to issue a book to the user
searchwindow	tkinter	used to search a book and holders details
viewallwindow	tkinter	used to view all book and holder details
windowsize_bg_settings	tkinter	used to set height,width and title for all windows in this application
connections	sqilte3	used to open,save and close connections to DB
addbook	sqilte3	Contains a query to add the details entered in addwindow to DB
deletion	sqilte3	Contains a query to delete a book number entered in deletewindow
fetching	sqilte3	Contains a query to display the all details of book, holders data from searchwindow and viewallwindow
issuebook	sqilte3	Contains a query to add the details entered in issuewindow to DB