📌 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! 🚀