Alumni Information System – Python MySQL Project


Alumni information system Python MySQL project. The Alumni management system Python MySQL project was developed to track the information of alumni of any institute. This free Python project to manage alumni data contains Python Source code and Backup of MySQL database.

alumni-information-system

Database Table structure

Sample Data Tables in MySQL

mysql> desc alumni;
+------------------+------------+------+-----+---------+----------------+
| Field            | Type       | Null | Key | Default | Extra          |
+------------------+------------+------+-----+---------+----------------+
| id               | bigint(20) | NO   | PRI | NULL    | auto_increment |
| name             | char(30)   | YES  |     | NULL    |                |
| fname            | char(30)   | YES  |     | NULL    |                |
| phone            | char(30)   | YES  |     | NULL    |                |
| email            | char(30)   | YES  |     | NULL    |                |
| stream           | char(30)   | YES  |     | NULL    |                |
| pass_year        | char(4)    | YES  |     | NULL    |                |
| hqualification   | char(40)   | YES  |     | NULL    |                |
| current_position | char(30)   | YES  |     | NULL    |                |
| dob              | date       | YES  |     | NULL    |                |
| c_city           | char(20)   | YES  |     | NULL    |                |
| c_country        | char(30)   | YES  |     | NULL    |                |
| employement      | char(30)   | YES  |     | NULL    |                |
+------------------+------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

Command to generate alumni table

create table alumni ( id int(11) primary key auto_increment, name  char(30), fname char(30), email char(30), stream char(30),
-> pass_year  char(4), hqualification char(40), current_position char(30), dob date, c_city char(30),
-> c_country  char(30), employement  char(30) );

Python code to connect MySQL with Python

import mysql.connector
conn = mysql.connector.connect(host='localhost', database='alumni', user='root', password='')
    cursor = conn.cursor()
    sql ="select * from alumni"
    cursor.execute(sql)

The search facility of alumni information system

  • Search alumni older than certain years
  • Business-wise alumni searching facility
  • Facility to search alumni according to city and country.
  • Search alumni by name or father Name

Different Types of Reports Generated

  • Whole Institute’s Alumni List
  • Session wise alumni list
  • City wise alumni List
  • Country-wise Alumni list
  • Position wise alumni List
  • Higher Education-wise Alumni list
  • Business-wise alumni List

Download Source code – alumni information system

How to run Downloaded Project

  1. Source code is in the zip format, so before anything else, You need to unzip the downloaded file first into a folder
  2. Unzip folder contains 2 files  a) Python source code to manage alumni   2) MySQL backup of the sample database
  3. Restore Backup data in MySQL and make necessary changes in Python source code like MySQL password and database name.
  4. Open Python Source code file in IDLE/IDE and run the code

Working of Project

Please check the attached youtube video for a better understanding of code and its working.

Output Screenshots

 

summary

This is a very small alumni management system project written in core python using MySQL but has full potential to serve any type of educational institution. If you will download this code and check the code, You will be surprised to know how easy to manage alumni information. Hope this project will serve its purpose well.

Print Friendly, PDF & Email

Related Posts

If you like CBSEToaday and would like to contribute, you can also write an article using submit article or mail your article to contribute@cbsetoday.com See your article appearing on the cbsetoday.com main page and help other students/teachers.