๐Ÿ“Œ 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
Image description

๐Ÿ“Š Main Program Interface

Image description

๐Ÿ› ๏ธ 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! ๐Ÿš€