๐ 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! ๐