🚀 Student Management System - A Python & MySQL-Based Solution

📌 IntroductionManaging student data efficiently is crucial for educational institutions. Student Management System is a powerful Python-based solution that integrates MySQL for seamless database operations. This open-source project allows users to perform CRUD operations, search student records, and even export data to CSV files.

🔹 Features

✅ Add Student – Easily add new student records to the database.✅ Delete Student – Remove students by ID.✅ Update Student – Modify student information effortlessly.✅ Search Student – Find students using ID or name.✅ Display All Students – View all stored records.✅ Export to CSV – Download student records for external use.

🛠️ Getting Started

🔹 Prerequisites

Ensure you have the following installed:

Python 3.x – Download Here

MySQL – Install MySQL

🔹 Database Setup

1️⃣ Open MySQL and create a new database:

mysql -u root -p
CREATE DATABASE student_management;
USE student_management;

2️⃣ Create the students table:

CREATE TABLE students (
id VARCHAR(10) PRIMARY KEY,
name VARCHAR(50),
surname VARCHAR(50),
dob DATE,
address VARCHAR(100),
nationality VARCHAR(50),
faculty VARCHAR(50),
department VARCHAR(50),
specialization VARCHAR(50),
year VARCHAR(10)
);

📥 Installation

Clone the repository and install dependencies:

git clone https://github.com/medjahdi/student-management-system.git
cd student-management-system
pip install mysql-connector-python termcolor

🚀 Running the Application

Launch the program with:

python start.py

📂 Project Structure

📌 start.py – Main script to run the application.📌 login.py – Handles authentication with hashed passwords.📌 app.py – Contains CRUD operations & export functionality.📌 README.md – Project overview.

🔒 Login Security
The application uses SHA-256 hashed passwords for authentication. The default password is "nova".

🖼️ Screenshots

💻 Login Screen

📊 Main Program Interface

🛠️ Contributing

We welcome contributions! Follow these steps:
1️⃣ Fork the repo.2️⃣ Create a feature branch: git checkout -b feature/YourFeatureName.3️⃣ Commit changes: git commit -m 'Add feature XYZ'.4️⃣ Push: git push origin feature/YourFeatureName.5️⃣ Open a pull request.

📜 License

🔒 This project does not have a license. All rights reserved by @medjahdi.

📩 Contact & More

💻 GitHub: Student Management System🌐 Portfolio: medjahdi.github.io📧 Email: medjahdi.mohamed@outlook.com

📌 Let me know what you think about this project in the comments! 🚀