In this project, we create a library database for the users to borrow and return books from a made-up library system called Daisy Library.
- tkinter
- os
- csv
- sqlite3
- webbrowser
- Showing Books
- Showing Members
- Showing Lent Books
- Adding a Book
- Removing a Book
- Registering a Member
- Removing a Member
- Lending a Book
- Returning a Book
- Adding Multiple Books (with a csv file)
- Adding Multiple Members (with a csv file)
- Some of the main features are hidden in a paned window. (More options button has to be clicked to see)
- About us link to see the website of the made-up Daisy Library System
If the system has no books in it, the user is informed by the warning message which is shown below:
If the system has no members in it, the user is informed by the warning message which is shown below:
As the user clicks the More Options
button, a paned window appears on the main window's right side with other buttons.
- Adding a book to the system
- Removing a book by their name
- Registering a new member to the system
- Removing a member by their member ID
- Lending a book to a member
- Returning a book to the system
- Adding multiple books to the system (only CSV files supported)
- Registering multiple members to the system (only CSV files supported)
- A URL linked to the website of the Daisy Library System
To do so; first, the user clicks the Add Book
button:
Then it is expected from the user to fill in the required information about the book:
An error message will be shown if the user does not fill in all the fields in the window:
As the user fills in all the fields; they will answer a question box if they are certain about the book's information. If the answer is yes, another message box informs the user:
The user can see the book when they click the Show Books
button this time as the database has a book in the system now:
First, the user clicks the Remove Book
button:
Then, the user writes down the name of the book that they want to remove, and after a confirmation, the referred book will be removed from the system:
To do so; first; the user clicks the Register Member
button:
Then it is expected from the user to fill in the required information about the member:
After a confirmation, the member is added to the system:
The user can see the member when they click the Show Members
button this time as the database has a member in the system now:
First, the user clicks the Remove Member
button:
Then, the user writes down the member no of the referring member that they want to remove, and after confirmation, the referred member will be removed from the system:
First, the user clicks the Lend Book
button:
Then, the user writes down the name of the book and the member no of the member who wants to borrow the book:
After a confirmation; the book is lent to the referred member:
The user can check the borrowed books from the Show Lent Books
button:
As the user wants to return the book; first, click the Return Book
button and enter the name of the book:
The user can add multiple books or register multiple members if the appropriate csv file is imported.
Firstly, the user clicks the Add Multiple Books
or Add Multiple Members
button:
Then the user chooses the related csv file:
After the successful registration, the user can check the updated lists of the books and the members:
Updated Lists: