#📚 Library Management System

A simple terminal-based Library Management System built using Python and MySQL as part of my Class 12 Computer Science practical.

This project allows users to manage books and student records by connecting a Python application to a MySQL database.

---

✨ Features

• Add new books
• View available books
• Update book records
• Delete books
• Manage student records
• Store data using MySQL

---

🛠️ Tech Stack

• Language: Python
• Database: MySQL
• Library: mysql-connector-python

---

🚀 Getting Started

###Prerequisites

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

Install the MySQL connector using:

pip install mysql-connector-python

📖 What I Learned

While building this project, I learned: Connecting Python with MySQL Writing SQL queries Performing CRUD (Create, Read, Update, Delete) operations Organizing Python programs into multiple files Debugging database connection issues

🔮 Future Improvements

Add a graphical user interface (Tkinter or PyQt) Add book search by title or author Add user authentication Generate reports for issued books Improve error handling