Project Title: Library Management System

Overview

This project is a library management system designed to manage borrowers, books, and transactions. A user-friendly GUI is implemented using Tkinter.

prerequisites

To run this project, ensure the following software and tools are installed:

Python Installation

• Download Python (version 3.9 or later) from the official Python website. https://www.python.org/downloads/

• During installation, ensure you check the box to "Add Python to PATH."

MySQL INstallation

• Download MySQL Community Server from the MySQL website. https://dev.mysql.com/downloads/mysql/

• Install MySQL Workbench (optional) for an easy GUI for managing the database.

• Configure MySQL with a root password during installation.

intall MySQL connector for pyhton

• Run the following command in your terminal or command prompt: pip install mysql-connector-python

Install Tkinter (Pre-installed with Python on most systems)

• For Linux: sudo apt-get install python3-tk

• For Windows and MacOS: Tkinter is included with the Python installation by default.

Optional: Using an Integrated Development Environment (IDE)

• Install Visual Studio Code (VS Code): Download and install VS Code https://code.visualstudio.com/

• Install MySQL Extension for VS Code:

--Install the "MySQL" extension by searching for it in the Extensions Marketplace (Ctrl+Shift+X).

-- The extension provides a connection manager for interacting with the MySQL database directly in VS Code.

Running the Project

• Set up the database using the provided SQL script

• Update the database connection details in the Python script

• Run the main Python file: python guim.py

Troubleshooting

• If you encounter any issues, ensure:

--Python and MySQL installations are correctly added to the system PATH.

--All required Python packages are installed: pip install mysql-connector-python