📚 Library Management System

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.

📌 Required Modules:

• tkinter
• os
• csv
• sqlite3
• webbrowser

📌 Main features:

• 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)

📌 Extra features:

• 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

---

📖~☕ Main Features

Main Layout

Showing Books:

No Book Error:

If the system has no books in it, the user is informed by the warning message which is shown below:

Showing Members:

No Member Error:

If the system has no members in it, the user is informed by the warning message which is shown below:

More Options:

As the user clicks the More Options button, a paned window appears on the main window's right side with other buttons.

More Options Layout:

• 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

📘 ➕ 📚 Adding a Book:

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:

📖 ~ 📋 Show Books:

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:

📚 ➖ 📘 Removing a Book:

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:

👤 ➕ 👥 Registering a Member:

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:

👥 ~ 📋 Show Members:

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:

👥 ➖ 👤 Removing a Member:

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:

📘 ➡️ 👤 Lending a Book:

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:

📘 ➡️ 📚 Returning a Book:

As the user wants to return the book; first, click the Return Book button and enter the name of the book:

📗 ➕ 📘 ➕ 📚 Adding Multiple Books and Registering Multiple Members:

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: