Student Management System Project in Python with MySQL

Introduction

People have benefited a lot since the invention of the computer. Today, we can easily manage human management work using many software tools. Student management as such is a tool for handling students' data. For example, general information(name, address, DOB, etc.), admission details, grading system, attendance, and others relevant to the school or college students. 

In this tutorial, we'll create a student management system project in python using Tkinter and MySQL database.

Our program handles the following tasks:

1. Add new data of a student

2. View the information of an existing student

3. Update or modify a student's data, and

4. Delete the record of a student

👉Visit Also: Meditation App in Python Tkinter: Practice Deep Breathing

The Project Details

The graphical interface of this student manager program is managed by the Tkinter library. The PyMySQL package is used here to manage database operations with python. 

The project folder contains three python files, main.py, custom.py, and credentials.py. As the name of main.py, it handles all the tasks. custom.py has the several information about the color and font used by the main program. credentials.py or the final file contains credentials to log in to the MySQL server.

Since we'll be working with the database, you will need to install a MySQL server on your system. If you already have it, follow the next step.

Find more project related to Python and MySQL from here.

👉Library Management System Project in Python with MySQL

👉Create a Login and Registration form using Python and MySQL

👉Contact Management System Project in Python with MySQL

Create a Database and a Table

Create a database with this name: "student_management"

create database student_management;

Create a table "student_register" under the "student_management" database.

create table student_register(
	f_name VARCHAR(50) NOT NULL,
	l_name VARCHAR(50) NOT NULL,
	course VARCHAR(30) NOT NULL,
	subject VARCHAR(50) NOT NULL,
	year Int(10) NOT NULL,
	age Int(10) NOT NULL,
	gender char(10) NOT NULL,
	birth DATE NOT NULL,
	contact VARCHAR(15) NOT NULL,
	email VARCHAR(100) NOT NULL,
	PRIMARY KEY ( contact )
);

Requirements and Installation

Use pip3 for Linux and Mac.

Install PyMySQL

☛pip install PyMySQL

Install Tkinter

☛pip install tk

What can you learn from this project?

• Creating a graphical interface with Tkinter: Creating Tkinter window, frame, label, input widget, buttons, etc.

• Connecting Python to MySQL: How to connect python to MySQL, access data in a python table, retrieve data from a table, update operation, and more.

• Creating python modules to manage various tasks.

• Object Orient Programming: Using classes, objects, etc.

Source Code

Download the source code from my GitHub page(https://github.com/subhankar-rakshit) through the download button.

 

Summary

In this tutorial, we discussed how to create a student management system in python. It's a python project using Tkinter and MySQL that can handle relevant data to school or college students. Users need to follow some basic things before using this student manager application. For example, Installing MySQL server and all required modules or packages, creating a database and a table, etc.

The code length or size is not suitable for copying and pasting. I added my GitHub page link there; you can download the zip file of this project also, through the Download Button.

I hope you enjoyed this tutorial. If you have any questions about this python project, leave your comments below. You'll receive an immediate response.

To get more lovely Tkinter Examples, visit the separate page created only for Python Projects. Some examples are given below.

👉Language Translator App with Python Tkinter - Google Translate

👉Image to Pencil Sketch Converter in Python - Tkinter Project

👉Image to Cartoon Converter in Python - Tkinter Project

👉An Advanced Alarm Clock using Python Tkinter

Thanks for reading!💙

PySeek