---

Library Management System

A CLI based Library Management System, enabling efficient management of library resources & member operations. Implemented a comprehensive set of functionalities, including book management, member registration, book issuance, & return processes, enhancing the overall efficiency & effectiveness of library operations.

Built using Python programming language, MySQL database management language, file handling, pymysql, database management.

How To Run

• Download both Python programming language & MySQL from their official website

  • Python : [https://www.python.org/downloads/]

  • MySQL : [https://www.mysql.com/downloads/]

  • Pymysql : Execute the following in the Command Prompt(CMD):

    pip install pymysql
    

• Download the files Main.py, Operations.py, Library_MySQL_Password.txt & Optional : Create_Sample_Database.py

• Update the text contained in "Library_MySQL_Password.txt" to your mysql & library management password; eg, eshansud

• Optional : To create a sample database execute Create_Sample_Database.py before executing Main.py

  Or

  Execute the following commands in the MySQL client:

     CREATE DATABASE WORLD_LIBRARY;
  
     USE WORLD_LIBRARY;
  
     CREATE TABLE BOOKS(
     BOOK_ID INT(4) PRIMARY KEY,
     BOOK_NAME VARCHAR(20) NOT NULL,
     AUTHOR VARCHAR(20) NOT NULL,
     TOTAL_COPIES INT(3) NOT NULL,
     ISSUED_COPIES INT(3));
  
     CREATE TABLE MEMBERS(
     MEMBER_ID INT(4) PRIMARY KEY,
     PASSKEY VARCHAR(10) NOT NULL UNIQUE,
     FIRST_NAME VARCHAR(10) NOT NULL,
     MIDDLE_NAME VARCHAR(10),
     LAST_NAME VARCHAR(10) NOT NULL,
     GENDER VARCHAR(10) NOT NULL,
     DOB DATE NOT NULL,
     ADDRESS VARCHAR(30) NOT NULL,
     BOOK_ID1 INT(4),
     BOOK_ID2 INT(4),
     BOOK_ID3 INT(4),
     BOOK_ID4 INT(4));
  
     CREATE TABLE ISSUE_DETAILS(
     MEMBER_ID INT(4) NOT NULL,
     BOOK_ID INT(4) NOT NULL,
     ISSUED_DATE DATE NOT NULL,
     DUE_DATE DATE NOT NULL,
     RETURNED_DATE DATE,
     RECORD_TYPE CHAR(6));
  

• Execute Main.py to start the program

---

Admin Operations:

Operations under the control of the Admin

i. Display All Books

ii. Add New Book

iii. Update Existing Book

iv. Remove Book

v. Search Book By: Book ID

vi. Search Book By: Book Name

vii. Search Book By: Author

viii. Order Books By: Number of Total Copies

ix. Order Books By: Number of Issued Copies

x. Search Member Details

xi. Change Member Details

xii. Remove Member Details

xiii. Display Issue Details of Book

xiv. Display Issue Details Member

xv. Display Issue Details of Open Records

xvi. Display Issue Details of Closed Records

xvii. Change Admin Password

xviii. Log Out

Member Operations:

Operations under the control of the Members

i. Display All Books

ii. Issue Book

iii. Return Book

iv. Check Issued Books

v. Change Password

Vi. Log Out

---