Student Management System in Python

Introduction :

Student Management System is made using python with tkinter gui and Database used is mysql. This management system consists of the Superadmin login,admin login, faculty login, student login. This can make the work of the college more simple.

Modules Used :

• Tkinter
• mysql-connector python
• tkcalendar
• tktooltip
• PIL (Python Imaging Library)

Working :

✳️Types of Login -

1. Super Admin - Super admin can add the admin and manages the admin or he can update the admin or can change his own password.
2. Admin - Admin can add the faculty, manage the faculty, add the student, manages the Student and can update the fees record or add the fees record.
3. Faculty - Faculty can mark the attendance for the specified date by selecting the class and division. Faculty can also view the student records. Faculty can assign the class teacher by themselves only.
4. Student - Student can see his profile and can view his attendance history or fees paid history.
   

✳️ Database Design -

The database is design in such a way that when a student, admin or faculty is added the database automatically assigns the id to them. I have used the concept like stored procedure, function and triggers to do this process. Also the attendance can be recorded and used such query.

Project Video Link :

If you want to see the detail output of my project - Click here

Installation Process :

Follow these steps to set up and run the Student Management System:

Step 1: Clone the Repository

git clone https://github.com/PrathameshDhande22/Student-Management-System-in-Python.git

Step 2: Install MySQL Server

Download and install MySQL server locally on your machine from MySQL Official Website

Step 3: Run the Database Script

Execute the Script.sql file in your MySQL server to create the database and tables:

- Open MySQL Command Line or MySQL Workbench
- Run: source Resources/Script.sql

Step 4: Install Dependencies

Install all required Python dependencies using uv sync and activate the virtual environment:

uv sync
.venv\Scripts\activate

Step 5: Update Configuration

Edit the config.ini file with your MySQL database credentials:

- database username
- database password
- database host
- database name

Step 6: Run the Application

Execute the application:

py app.py

Author : Prathamesh Dhande