Student Management System in Python(Desktop Application)

In this tutorial, we are going to implement an attractive and user friendly desktop application Student Management System. This application is used to store the student's data. And we can use this application as a minor project for our college. This application is basically implemented using the python framework Tkinter which provides the tools to implement the desktop application. 

I have implemented this application for the coaching purpose which is using real time in my friend's coaching.

Working of Student management system

I have created 2 frames one frame storing the data and other frame for showing the data. 

Store data form

I am storing some of the information of each student like roll number, name, father's name, branch, year, contact number and address. I have given 4 functionalities for adding the data,  updating the data, deleting the data and clear the data. And all the validations are used here like all fields are required, delete data if the data is present in the database, update data if data is fetched from the database and available in the database.

Add Button : Add Button is used to add the information of the student into the database. 

Update Button : Update Button is used to update the data into the database. Firstly select the data from the tree view then data is filled into the field then change the field which you want to update then simply click on the update button for updating the data.

Delete Button : Delete Button is used to delete the data. Simply select a data from the tree view then click on the delete button for deleting the data from the database.

Clear Button : Clear Button is used to clear the fields only like if you filled all the fields again or incorrect but you want to fill another data just simply click on the clear button to clean the fields. 

Show data form

This form shows all the record which are stored in our database at the top side there is a list, in that list there are two options roll number and contact number and there's one more field  searching the data based on the roll number or contact number. And in the bottom of the search by,  there is a label total records which shows the total number of student records of our database. And at the second frame there is one more frame for the tree view. Tree view  shows the complete information of all the students. 

Note : Make sure before running the project, you'll also have to setup project and for use the project, You import student_management_system.sql file in xampp or wampp server. For importing (Go to new -> Create dataset with name (student_management_system) -> click on import -> choose file -> choose student_management_system.sql file -> click on Go-> Done. Now you can use the project.

1. Just fill all the fields with the data of a student.

2. When you click on the Add button to add the data into the database, a messagebox will be pop up and show the message "Record has been submitted".

4. If you want to update the data, just click on the any row from the tree view and data will be filled in all the fields, just simply change the data which you want to change and click on the update button to update the data into the database.

3. If you want to delete the data, just click on any row which is showing in the Tree view (window) and data will be filled in all the fields and simply click on the delete button to delete the data.

4. If you want to search a single record with the help of roll number. Just choose a roll number from the list and enter the roll number in the next fields and click on the show button to show the record of a given roll number. And you can also search a record with the help of the contact number, select a contact from the list and write a contact number in the another field and simply click on the show button  to show the data of a given contact number.

5. If you want to show all the records of the student which is stored in the database,  just simply click on the show all button to show all the record  of the students.

Source code and how to use:

1. Go to my GitHub and download code : Student Management System

2. After download, Extract the folder.

3. Then connect the student_management_system.sql to the wampp or xampp server. 

4. Download xampp for windows : Download xampp

5. import student_management_system.sql file in xampp or wampp server. For importing (Go to new -> Create dataset with name (student_management_system) -> click on import -> choose file -> choose student_management_system.sql file -> click on Go-> Done. Now you can use the project. If you are trouble in xampp server to connect the student management system database, so you comment below, i will help you.

4. Then Go into the folder.

5. Open the command prompt and go to the project folder with cd command.

6. Write (python tkinter1.py) in your prompt.

7. Now you can use the model. 

Video Tutorial

Thank You !!!!!!!