Student Data Management System

A GUI-based Student Data Management System developed using Python, Tkinter, and MySQL. The application provides a simple and user-friendly interface to manage student records through CRUD (Create, Read, Update, Delete) operations with secure login authentication.

---

Project Overview

The Student Data Management System is designed to simplify the process of maintaining student information in a database. It allows administrators to add, view, search, update, and delete student records through an interactive graphical interface.

The project demonstrates practical implementation of:

• Python Programming
• GUI Development with Tkinter
• MySQL Database Connectivity
• CRUD Operations
• Login Authentication System
• Database Design and Management

---

Features

Login Authentication

• Username and Password Verification
• Restricted Access to the Main Application
• Error Handling for Invalid Credentials

Database Management

• Automatic Database Creation
• Automatic Table Creation
• MySQL Integration

Student Record Management

• Add New Student
• View All Students
• Search Student by UID
• Update Student GPA
• Delete Student Records

CRUD Operations

• Create Records
• Read Records
• Update Records
• Delete Records

User Interface

• Graphical User Interface using Tkinter
• Interactive Buttons and Input Fields
• Message Box Notifications
• Simple and Easy Navigation

---

Technologies Used

Technology	Purpose
Python	Application Development
Tkinter	GUI Development
MySQL	Database Management
mysql-connector-python	Database Connectivity

---

Database Schema

Database Name

student_db

Table Name

student

Table Structure

Column Name	Data Type	Description
rollno	INT (AUTO_INCREMENT)	Primary Key
uid	VARCHAR(225)	Unique Student ID
name	VARCHAR(225)	Student Name
classs	VARCHAR(255)	Class Name
gpa	VARCHAR(255)	Student GPA

---

Installation Guide

Step 1: Clone Repository

git clone https://github.com/yourusername/student-data-management-system-python.git

Step 2: Navigate to Project Folder

cd student-data-management-system-python

Step 3: Install Required Package

pip install mysql-connector-python

or

pip install -r requirements.txt

Step 4: Configure MySQL

Open student_management.py and update:

password='your_password'

Replace with your MySQL root password.

---

Step 5: Run Application

---

Default Login Credentials

Username: admin
Password: 123

---

Project Structure

student-data-management-system-python
│
├── main.py
├── requirements.txt
├── README.md
├── .gitignore
│
└── screenshots

---

Learning Outcomes

Through this project, I gained hands-on experience in:

• Python Programming
• Tkinter GUI Development
• MySQL Database Integration
• CRUD Operations
• Event-Driven Programming
• Database Design
• Error Handling
• Desktop Application Development

---

Future Enhancements

• Student Result Management
• Attendance Management
• Export Records to Excel/PDF
• Role-Based Authentication
• Improved Search Filters
• Dashboard Analytics
• Data Validation
• Modern UI Design

---

Author

Jarnur Mhaskar

B.Sc. Information Technology Graduate MCA Appearing

Connect With Me

GitHub: https://github.com/jarnurmhaskar18-ux

LinkedIn: www.linkedin.com/in/jarnur-mhaskar-233a8728b

---