📚 Library Management System

A command-line based Library Management System built using Python and MySQL Connector. This project allows users to manage books and book issuance records efficiently through a terminal interface. Designed and developed as a school project to demonstrate practical database management skills.

---

🚀 Features

📘 Book Record Module

• Add new books with details like ID, name, writer, and publisher
• Delete books using Book ID
• View all book records
• Search for books by:
  • Book ID
  • Book Name
  • Writer Name
  • Publisher

📖 Book Issuing Module

• Record book issuance with issuer ID, book ID, date of borrow, return date, and late fee
• Delete records based on Issuer ID
• Update return dates
• View all issue records
• Search by:
  • Issuer ID
  • Book ID
  • Date of Borrow
  • Date of Return

📊 Combined Record View

• Join book and issue tables to display merged data for cross-reference

🔐 Password Protection

• Access to the system is password-protected (123456 by default)

---

🧰 Tech Stack

• Python 3.x
• MySQL
• mysql-connector-python

---

🗂️ Database Schema

This project requires a MySQL database named lib_rec with the following tables:

-- Book table
CREATE TABLE book (
    ID INT PRIMARY KEY,
    book_name VARCHAR(100),
    writer VARCHAR(100),
    publisher VARCHAR(100)
);

-- Issue/Record table
CREATE TABLE record (
    issuer_ID INT,
    BOOK_ID INT,
    date_of_borrow DATE,
    date_of_return DATE,
    late_fee_per_day INT,
    FOREIGN KEY (BOOK_ID) REFERENCES book(ID)
);