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.
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
- Source code is in the zip format, so before anything else, You need to unzip the downloaded file first into a folder
- Unzip folder contains 2 files a) Python source code to manage alumni 2) MySQL backup of the sample database
- Restore Backup data in MySQL and make necessary changes in Python source code like MySQL password and database name.
- 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.