Library Management System

A console-based Library Management System developed in Python using MySQL.

Features

• Add new books
• Search books
• Update and delete books
• Issue and return books
• View borrowed register
• View student borrowing history

Technologies Used

• Python 3
• MySQL
• mysql-connector-python

Run the Project

pip install -r requirements.txt
python library_management_system.py

Database Setup

Run the SQL script in MySQL:

SOURCE database_schema.sql;

Author

Prerana Banerjee