Library Management System

This system is provided to manage library resources efficiently, allowing easy tracking of books, members, and borrowed items. The template offers a simple yet comprehensive way to organize and monitor library operations with a user-friendly interface. It includes tables for books, members, and borrowers, as well as a quick navigation menu for easy access.

Main Features:
+ Total Borrowing Book Chart: A visual representation of the total number of books borrowed, providing an overview of the borrowing activity in the library.
+ Quick Button Section:
- Add Book: Add a new book entry to the Book table.
- Add Member: Add a new member to the Member table.
- Add Borrower: Record a new borrowing transaction in the Borrower database.

Library Overview Layouts:
- Gallery View of Book Table: A visual representation of all the books in the library with their covers.
- Table View of Borrower: A detailed table showing all current and past borrowers, linked to the Book table.

Navigation Menu:
- Books: Quickly access the list of books in the library.
- Members: View all library members and their details.
- Borrowers: Track who has borrowed books and view related records.

Tables:
Book Table: This table stores all the details about the books available in the library.
- Title: The name of the book.
- Category: The genre or category of the book (e.g., Fiction, Non-fiction, Technology).
- Author: The writer(s) of the book.
- Book Cover: A visual image representing the book cover.
- Book Total: The total number of copies of the book in the library.
- Amount in Stock: The number of copies currently available for borrowing(auto generated base on book borrowed).
- Price: The cost per book.
- Status: Whether the book is available for borrowing (e.g., Available, Unavailable) it auto set, base on book borrowed .
- Book ID: A unique identifier for each book.
- Create Time: Timestamp for when the book entry was created.
- Modify Time: Timestamp for when the book entry was last updated.

Member Table: This table keeps track of the library members.
- Name: The full name of the member.
- ID: A unique identifier assigned to each member.
- Address: The member’s location or class (for students).
- Phone: The contact number of the member.
- Create Time: Timestamp for when the member entry was created.
- Modify Time: Timestamp for when the member entry was last updated.

Borrower Database: This database links borrowed books to the corresponding members.
- Member Name: The name of the member borrowing the book (linked to the Member table).
- Note: Any notes or remarks about the borrowing (e.g., duration, condition).
- Book: A reference to the borrowed book (linked from the Book table).
- Borrow Date: The date the book was borrowed.
- Create Time: Timestamp for when the borrowing record was created.
- Modify Time: Timestamp for when the borrowing record was last updated.