🏫 School Management Program (Terminal-Based)

This project is a terminal-based school management application developed using Python and MySQL. It allows seamless management of student records through a simple and intuitive command-line interface. Built with pymysql for database connectivity and prettytable for formatted terminal output, this project is perfect for beginners learning database integration and backend operations in Python.

📌 Features

• Add, view, update, and delete student records
• Display records in a clean table format using PrettyTable
• Persistent data storage with MySQL
• Modular and maintainable code structure
• Beginner-friendly project structure for learning

🛠️ Tech Stack

• Python
• MySQL
• pymysql – to interact with the MySQL database
• prettytable – to present output in a readable tabular format

🚀 Getting Started

To run this project locally:

1. Clone the repository

git clone https://github.com/MohitSoni2021/School-management-programe.git
cd School-management-programe

2. Install the dependencies

Make sure you have Python installed, then install the required packages:

pip install pymysql prettytable

3. Set up the MySQL database

Log in to your MySQL server and create a database:

CREATE DATABASE school_db;
USE school_db;

Then run the provided SQL script (if available) or create tables as required by the Python code.

4. Run the program

python main.py

Ensure your MySQL credentials in the script match your local configuration.

📚 Learning Outcome

This project helps you understand:

• How to perform CRUD operations using Python
• How to connect Python with MySQL using pymysql
• How to format and display data using prettytable
• Building real-world terminal applications

🙌 Acknowledgements

Made with ❤️ by Mohit Soni as part of my learning journey.

---