DELHI PUBLIC SCHOOL

BAREILLY

SUBJECT- COMPUTER SCIENCE

ANNUAL PROJECT REPORT

TOPIC -ALUMNI MANAGEMENT SYSTEM

Submitted To- Submitted By-

Mr. Pankaj Agarwal Divyanshu Singh

Sir XII ‘A’ PCM
PGT COMPUTER
SCIENCE

1
 ACKNOWLEDGEMENT

I would like to express my special thanks to gratitude to my teacher

Mr. Pankaj Agarwal sir as well as our principal Mr. V. K. Mishra sir
who gave me the golden opportunity to do this wonderful project on the
topic Alumni Management System, which helped me in doing a lot of
research. I am really thankful to them.

Yours sincerely
Divyanshu Singh
XII ‘A’ PCM
 CERTIFICATE

This is to certify that DIVYANSHU SINGH student of class

XII ‘A’ PCM has successfully completed the annual computer science
project on the topic Alumni Management System
under the guidance of Mr. Pankaj Agarwal.

……………….. ……………. ………………….

V.K. Mishra Examiner’s Pankaj Agarwal

Principal Signature Head of Department
Delhi Public School Computer Science
Bareilly
 CONTENTS

1. Project Synopsis
2. About the Frontend Software
3. About the Backend Software
4. Hardware and Software Requirements
5. Screenshots
6. Coding
7. Conclusion
8. Bibliography
 SYNOPSIS

The project Alumni Information System which allows get together old
students and new students of a school to communicate with each other.
The main purpose of this project is to provide all the detail about
Alumni, School, School Mates, Social Network, Opportunity, School
News, and Student. In this system students to know information about
each other and their current activities. The New students can ask about
career, subject details with old students who has completed his studies.
Alumni can also provide public posts on the system about possible
career opportunities or other school related news. Students who had
completed his studies and begin his professional carrier can be helpful
for other students and schools for providing guidelines for new students,
so this project Alumni Information System will help school and students
to be in contact with alumni.
 ABOUT THE FRONTEND
SOFTWARE

Software used: Python

Software version: 3.8

Python is an interpreter, high-level and general-purpose programming

language. Python's design philosophy emphasizes code readability with
its notable use of significant whitespace. Its language constructs and
object-oriented approach aim to help programmers write clear, logical
code for small and large-scale projects. Python was created in the late
1980s, and first released in 1991, by Guido van Rossum as a successor
to the ABC programming language. Python 2.0, released in 2000,
introduced new features, such as list comprehensions, and a garbage
collection system with reference counting, and was discontinued with
version 2.7 in 2020. Python 3.0, released in 2008, was a major revision
of the language that is not completely backward-compatible and much
Python 2 code does not run unmodified on Python 3.
 ABOUT THE BACKEND
SOFTWARE

Software used: MySQL

Software version: 8.0

MySQL is the world's most popular open source database. With its
proven performance, reliability and ease-of-use, MySQL has become
the leading database choice for web-based applications, used by high
profile web properties including Facebook, Twitter, YouTube, Yahoo!
and many more.
Oracle drives MySQL innovation, delivering new capabilities to power
next generation web, cloud, mobile and embedded applications.
 HARDWARE AND SOFTWARE
REQUIREMENTS

FRONTEND SOFTWARE: Python

MINIMUM SYSTEM REQUIREMENTS:

 Processors: Intel Atom® processor or Intel® Core™ i3 processor

 Disk space: 1 GB
 Operating systems: Windows* 7 or later, macOS, and Linux
 Python versions: 2.7.X, 3.6.X

RECOMMENDED SYSTEM REQUIREMENTS:

 Processors: Intel® Core™ i5 processor 4300M at 2.60 GHz or 2.59

GHz (1 socket, 2 cores, 2 threads per core), 8 GB of DRAM Intel®
Xeon® processor E5-2698 v3 at 2.30 GHz (2 sockets, 16 cores each,
1 thread per core), 64 GB of DRAM Intel® Xeon Phi™ processor
7210 at 1.30 GHz (1 socket, 64 cores, 4 threads per core), 32 GB of
DRAM, 16 GB of MCDRAM (flat mode enabled)

 Disk space: 2 to 3 GB

 Operating systems: Windows® 10, macOS, and Linux

BACKEND SOFTWARE: MySQL

MINIMUM SYSTEM REQUIREMENTS:

 2 CPU Cores
 2 GB RAM
 Disk I/O subsystem applicable to a write-intensive database

RECOMMENDED SYSTEM REQUIREMENTS:

 4 CPU Cores or more

 8 GB RAM or more
 RAID10 or RAID 0+1 disk setup


SCREENSHOTS
 CODING

import os
import mysql.connector

constr=mysql.connector.connect(host="localhost",\
user="root",\
passwd="")
print(constr)
mycursor=constr.cursor()

def RegisterAlumni():
mycursor.execute("use aldb")
L=[]
fname=input("Enter Your First Name : ")
L.append(fname)
lname=input("Enter Your Last Name :")
L.append(lname)
dob=input("Enter Dob in YYYY-MM-DD Format : ")
L.append(dob)
gender=input("Enter Your Gender : ")
L.append(gender)
add_c=input("Enter your correspondence address : ")
L.append(add_c)
add_of=input("Enter your official address : ")
L.append(add_of)
email=input("Enter your email address Ex: [email protected]: ")
L.append(email)
mob=input("Enter Your Mobile No: ")
L.append(mob)
cur_c=input("Enter City Name You Stay : ")
L.append(cur_c)
 com=input("Enter Company/Organization You are Working : ")
L.append(com)
desg=input("Enter Your Desgination in Company/Organization :
")
L.append(desg)
start_y=input("Enter Your Session Start Year in College: ")
L.append(start_y)
start_e=input("Enter Your Session End Year in College : ")
L.append(start_e)
branch=input("Enter Your Branch in College : ")
L.append(branch)
alid="al"+fname[0:2]+lname[0:2]+mob[0:4]
L.insert(0,alid)
alumni=(L)
sql="insert into alureg
(alu_id,fname,lname,dob,gender,add_corr,add_offc,email_add,mob
_no,curr_city,curr_company,desg,session_from,session_to,branch)
values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
mycursor.execute(sql,alumni)
constr.commit()
print("You Have Been Succesfully Registered: This is You
AlumniID ,Use This For Further Correspondence")
print(alid)
def ViewAlumniDetails():
mycursor.execute("use aldb")
print("Select the search criteria to View Details : ")
print("1. Fname")
print("2. Lname")
print("3. Company")
print("4. Stream")
print("5. City")
print("6. Session Start")
print("7. To View All Records")
ch=int(input("Enter the choice : "))
if ch==1 :
s=input("Enter First Name to Be Searched For")
 rl=(s,)
sql="select * from alureg where first_name like %s"
mycursor.execute(sql,rl)
elif ch==2:
s=input("Enter Last Name to Be Searched For")
rl=(s,)
sql="select * from alureg where last_name like %s"
mycursor.execute(sql,rl)
elif ch==3:
s=input("Enter Company Name to Be Searched For")
rl=(s,)
sql="select * from alureg where curr_company=%s"
mycursor.execute(sql,rl)
elif ch==4:
s=input("Enter Stream : ")
rl=(s,)
sql="select * from alureg where branch=%s"
mycursor.execute(sql,rl)
elif ch==5:
s=input("Enter City : ")
rl=(s,)
sql="select * from alureg where curr_city=%s"
mycursor.execute(sql,rl)
elif ch==6:
s=input("Enter Session Start Year ")
rl=(s,)
sql="select * from alureg where session_from=%s"
mycursor.execute(sql,rl)
elif ch==7:
sql="select * from alureg"
mycursor.execute(sql)
res=mycursor.fetchall()
print("The Alumni Details are as Follows")
print("(alu_id,first_name,last_name,dob,gender,add_corr,add_offc,e
mail_add,mob_no,curr_city,curr_company,desg,session_from,sessi
on_to,branch)")
 for x in res:
print(x)
def EditAlumni():
mycursor.execute("use aldb")
alid=input("Enter Alumni ID to be edited : ")
sql="select * from alureg where alu_id=%s"
ed=(alid,)
mycursor.execute(sql,ed)
res=mycursor.fetchall()
for x in res:
print(x)
print("")
print("Fields can be updated.....")
print("1. alu_id")
print("2. fname")
print("3. lname")
print("4. dob ")
print("5. gender")
print("6. add_corr")
print("7. add_offc")
print("8. email_add")
print("9. mob_no")
print("10.curr_city")
print("11.curr_company")
print("12.desg")
print("13.session_from")
print("14.session_to")
print("15.branch")
fld=input("Enter the field which you want to edit : ")
val=input("Enter the value you want to set : ")
sql="Update alureg set " + fld +"='" + val + "' where alu_id='" +
alid + "'"
sq=sql
mycursor.execute(sql)
print("Editing Done : ")
print("After correction the record is : ")
 sql="select * from alureg where alu_id=%s"
ed=(alid,)
mycursor.execute(sql,ed)
res=mycursor.fetchall()
for x in res:
print(x)
constr.commit()

def SearchAlumni():
mycursor.execute("use aldb")
print("Enter The Alumni ID")
aluid=input("Enter the Alumni ID for the alumni to be viewed :
")
sql="select * from alureg where alu_id=%s"
rl=(aluid,)
mycursor.execute(sql,rl)
res=mycursor.fetchall()
if res==None:
print("Record not Found . . . ")
return
print("The details of the students are : " )
print("(alu_id,fname,lname,dob,gender,add_corr,add_offc,email_ad
d,mob_no,curr_city,curr_company,desg,session_from,session_to,br
anch)")
for x in res:
print(x)

def DeleteAlumni():
mycursor.execute("use aldb")
aluid=input("Enter the Alumni ID for the alumni to be deleted :
")
sql="Delete from alureg where alu_id=%s"
rl=(aluid,)
mycursor.execute(sql,rl)
constr.commit()
def ScheduleEvent():
mycursor.execute("use aldb")
E=[]
ename=input("Enter Event Name to Schedule : ")
E.append(ename)
edate=input("Enter Event Date in YYYY-MM-DD :")
E.append(edate)
evenue=input("Enter Venue of Event :")
E.append(evenue)
estat=input("Enter Event Status as Completed Or Not Completed
:")
E.append(estat)
event=(E)
sql="insert into event (event_name,event_date,venue,status)
values (%s,%s,%s,%s)"
mycursor.execute(sql,event)
constr.commit()
print("You Have Succesfully Added A Event")

def ViewEventDetails():
mycursor.execute("use aldb")
print("Select the search criteria to View Event Details : ")
print("1. Event Name")
print("2. Venue")
print("3. Status")
print("4. To View All Records")
ch=int(input("Enter the choice : "))
if ch==1 :
s=input("Enter Event Name to Be Searched For")
rl=(s,)
sql="select * from event where event_name like %s"
mycursor.execute(sql,rl)
elif ch==2:
s=input("Enter Venue Name to Be Searched For")
rl=(s,)
sql="select * from event where event like %s"
 mycursor.execute(sql,rl)
elif ch==3:
s=input("Enter Status to Be Searched For")
rl=(s,)
sql="select * from event where status=%s"
mycursor.execute(sql,rl)
elif ch==4:
sql="select * from event"
mycursor.execute(sql)
res=mycursor.fetchall()
print("The Event Details are as Follows")
print("(Event_Name,Event_Date,Venue,Status)")
for x in res:
print(x)

def DeleteEvent():
mycursor.execute("use aldb")
ename=input("Enter the Event Name to be deleted : ")
sql="Delete from event where event_name=%s"
rl=(ename,)
mycursor.execute(sql,rl)
constr.commit()
def MainMenu():
while True:
print("Enter 1 : To Register Alumni")
print("Enter 2 : To View Alumni Details ")
print("Enter 3 : To Edit Alumni Details ")
print("Enter 4 : To Search Alumni ")
print("Enter 5 : To delete Alumni")
print("Enter 6 : To Add a Event")
print("Enter 7 : To Search a Event")
print("Enter 8 : To Delete a Event")
userInput = int(input("Please Select An Above Option: "))
print("\n")
if(userInput == 0):
create_database()
 if(userInput == 1):
RegisterAlumni()
elif (userInput==2):
ViewAlumniDetails()
elif (userInput==3):
EditAlumni()
elif (userInput==4):
SearchAlumni()
elif (userInput==5):
DeleteAlumni()
elif (userInput==6):
ScheduleEvent()
elif (userInput==7):
ViewEventDetails()
elif (userInput==8):
DeleteEvent()
else:
print("Enter correct choice. . . ")
break
MainMenu()

def AskChoiceAgain():
AksChcRun = input("\nwant To Run Again Y/N: ")
while(AksChcRun.lower() == 'y'):
MainMenu()
AskChoiceAgain()
 CONCLUSION

The aim of this Alumni Management System project is to build a system that
will be able to manage alumni data of a college and provide easy access to the
same. Alumni of a college generally stay in touch with their immediate friends
but find it hard to stay connected with other college mates. Contact between
alumni can be used to forge business connections and to gain references or
insight in a new field. New college students will be initially given a student login
ID. Access to the system can help them in building connections to help them in
their projects or for placements.
 BIBLIOGRAPHY

 google.com/
 wikipedia.com/
 python.org/
 mysql.com/
 BOOK: Computer Science with Python
BY:- Sumita Arora