lOMoARcPSD|29312395
IP Project FILE
diseño interiores (K.V. Ranga Reddy Law College)
Studocu is not sponsored or endorsed by any college or university
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
INFORMATICS PRACTICES
PROJECT
ON
“STUDENT MANAGEMENT”
PRESENTED TO CBSE
Prepared By:
Anushka Sharma
Anshika Sooi
Ayra
Session: 2022-2023
ANGELS’ ACADEMY
SENIOR SEC. SCHOOL
HARIDWAR
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
CONTENTS
Certificate
Acknowledgement
Introduction
Coding
Output
Bibliography
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
CERTIFICATE
This is to certify that the project “SCHOOL
MANAGEMENT” has been fabricated satisfactorily
by ANUSHKA SHARMA, AYRA, ANSHIKA SOOI
of class XII under the guidance of MS. LIPI GUPTA
during academic year 2022-2023.
Internal Examiner External examiner
(Sign) (Sign)
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
ACKNOWLEDGEMENT
This particular project “SCHOOL MANAGEMENT”
has been one of the amiable inspiring project assigned
to us for the success.
We pay thanks to our informatics practices teacher
MS. LIPI GUPTA under whose guidance we are able
to complete the project work.
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
INTRODUCTION
1. newstudent (): To add a new student.
2. displayStudent (): To display record of students.
3. updateStudent (): To update record of a student.
4. feeStudent (): To pay the fees of student.
5. SearchByName(name): To search a student’s record
by its name.
6. SearchByAdno(no): To search a student’s record by
its admission number.
7. Delete(no) : To delete a student’s record.
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
CODING
import mysql.connector
db=mysql.connector.connect(host="localhost",user="root",passwd=" " ,
database="test ")
cursor=db.cursor()
#1--MODULE FOR NEW ADMISSION
def newstudent():
sadmission_no=1
query ="CREATE TABLE IF NOT EXISTS STUDENTS(SADMISSION_NO
VARCHAR(10)PRIMARY KEY,SNAME VARCHAR(30),SCLASS
VARCHAR(5),SSECTION VARCHAR(5),SROLL_NO VARCHAR(5),FNAME
VARCHAR(30),MNAME VARCHAR(30),PHONE VARCHAR(12),ADDRESS
VARCHAR(100),GENDER VARCHAR(3),AGE VARCHAR(4),CATEGORY
VARCHAR(20))"
cursor.execute(query)
query= "SELECT * FROM STUDENTS"
cursor.execute(query)
x=cursor.fetchall()
if x!=[]:
query= "SELECT MAX(SADMISSION_NO) FROM STUDENTS"
cursor.execute(query)
for i in cursor:
no=int(i[0])
sadmission_no= no+1
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
print("ENTER RECORDS FOR:",sadmission_no)
sname=input("ENTER STUDENT'S NAME :")
sclass =input("ENTER CLASS :")
ssection=input("ENTER SECTION :")
sroll_no=input("ENTER ROLL_NO :")
fname=input("ENTER FATHER'S NAME :")
mname=input("ENTER MOTHER'S NAME :")
phone=input("ENTER CONTACT NO. :")
address=input("ENTER ADDRESS :")
gender=input("ENTER GENDER (M/F) :")
category=input("ENTER CATEGORY :")
sql="insert into
students(SADMISSION_NO,SNAME,SCLASS,SSECTION,SROLL_NO,FNAME,MNAM
E,PHONE,ADDRESS,GENDER,CATEGORY)
VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')"%(sadmission_no,sna
me,sclass,ssection,sroll_no,fname,mname,phone,address,gender,category)
cursor.execute(sql)
db.commit()
print("DATA SUCCESSFULLY ADDED!!!")
#2--MODULE TO DISPLAY STUDENT'S DATA
def displayStudent():
cursor.execute("SELECT * FROM STUDENTS")
for i in cursor:
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
print ("ADMISSION NO. IS :",i[0])
print ("NAME IS :",i[1])
print ("CLASS IS :",i[2])
print ("SECTION IS :",i[3])
print ("ROLL NO IS :",i[4])
print ("FATHER'S NAME IS :",i[5])
print ("MOTHER'S NAME IS :",i[6])
print ("CONTACT NO IS :",i[7])
print ("ADDRESS IS :",i[8])
print ("GENDER IS :",i[9])
print ("CATEGORY IS :",i[10])
x=input("")
#3--MODULE TO UPDATE STUDENT'S RECORD
def updateStudent():
admission_no=input("ENTER ADMISSION NO: ")
sql="SELECT * FROM STUDENTS WHERE SADMISSION_NO= %s"
cursor.execute(sql,(admission_no,))
data=cursor.fetchall()
if data:
print("PRESS 1 FOR NAME:-")
print("PRESS 2 FOR CLASS:-")
print("PRESS 3 FOR ROLL NO:-")
print("PRESS 4 FOR SECTION:-")
print("PRESS 5 FOR FATHER'S NAME:-")
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
print("PRESS 6 FOR MOTHER'S NAME:-")
print("PRESS 7 FOR ADDRESS:-")
print("PRESS 8 FOR GENDER:-")
print("PRESS 9 FOR CATEGORY:-")
choice=int(input("Enter Your Choice:--"))
if choice==1:
name=input("ENTER NAME OF THE STUDENT: ")
sql="UPDATE STUDENTS SET SNAME= %s WHERE SADMISSION_NO = %s"
cursor.execute(sql,(name,admission_no))
cursor.execute("COMMIT")
print("NAME UPDATED ! ! !")
elif choice==2:
std=input("ENTER CLASS OF THE STUDENT: ")
sql="UPDATE STUDENTS SET SCLASS= %s WHERE SADMISSION_NO= %s"
cursor.execute(sql,(std,admission_no))
cursor.execute("COMMIT")
print("CLASS UPDATED ! ! !")
elif choice==3:
roll_no=int(input("ENTER ROLL NO OF THE STUDENT: "))
sql="UPDATE STUDENTS SET SROLL_NO= %s WHERE SADMISSION_NO =
%s"
cursor.execute(sql,(roll_no,admission_no))
cursor.execute("COMMIT")
print("ROLL NO UPDATED ! ! !")
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
elif choice==4:
ssection=input("ENTER SECTION OF THE STUDENT: ")
sql="UPDATE STUDENTS SET SSECTION= %s WHERE SADMISSION_NO =
%s"
cursor.execute(sql,(ssection,admission_no))
cursor.execute("COMMIT")
print("SECTION UPDATED ! ! !")
elif choice==5:
fname=input("ENTER FATHER'S NAME OF THE STUDENT: ")
sql="UPDATE STUDENTS SET FNAME= %s WHERE SADMISSION_NO = %s"
cursor.execute(sql,(fname,admission_no))
cursor.execute("COMMIT")
print("FATHER'S NAME UPDATED ! ! !")
elif choice==6:
mname=input("ENTER MOTHER'S NAME OF THE STUDENT: ")
sql="UPDATE STUDENTS SET MNAME= %s WHERE SADMISSION_NO =
%s"
cursor.execute(sql,(mname,admission_no))
cursor.execute("COMMIT")
print("MOTHER'S NAME UPDATED ! ! !")
elif choice==7:
address=input("ENTER ADDRESS OF THE STUDENT: ")
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
sql="UPDATE STUDENTS SET ADDDRESS= %s WHERE SADMISSION_NO =
%s"
cursor.execute(sql,(address,admission_no))
cursor.execute("COMMIT")
print("ADDRESS UPDATED ! ! !")
elif choice==8:
gender=input("ENTER GENDER OF THE STUDENT: ")
sql="UPDATE STUDENTS SET GENDER= %s WHERE SADMISSION_NO =
%s"
cursor.execute(sql,(gender,admission_no))
cursor.execute("COMMIT")
print("GENDER UPDATED ! ! !")
elif choice==9:
category=input("ENTER CATEGORY OF THE STUDENT: ")
sql="UPDATE STUDENTS SET CATEGORY= %s WHERE SADMISSION_NO =
%s"
cursor.execute(sql,(category,admission_no))
cursor.execute("COMMIT")
print("CATEGORY UPDATED ! ! !")
#4--MODULE TO ENTER FEES OF THE STUDENTS
def feeStudent () :
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
createTable ="CREATE TABLE IF NOT EXISTS FEES(SADMISSION_NO
VARCHAR(10),MONTH INT ,TUTION_FEES INT,VVN INT ,COMPUTER_FEES INT
,MUSIC_FEES INT, TOTAL INT)"
cursor.execute(createTable)
admission_no=input("ENTER ADMISSION NO OF THE STUDENT :")
month=int(input("\n ENTER MONTH IN NUMERIC FORM (1-12) : "))
tutionfee=int(input("\n ENTER TUTION FEES : "))
vvn=int(input("\n ENTER VVN : "))
computerfee=int(input("\n ENTER COMPUTER FEES : "))
musicfee=int(input("\n ENTER MUSIC FEES : "))
total = tutionfee + vvn + computerfee + musicfee
sql="INSERT INTO
FEES(SADMISSION_NO,MONTH,TUTION_FEES,VVN,COMPUTER_FEES,MUSIC_FE
ES,TOTAL) VALUES(%s,%s,%s,%s,%s,%s,%s)"
values=(admission_no,month,tutionfee,vvn,computerfee,musicfee,total)
cursor.execute(sql,values)
cursor.execute("COMMIT")
cursor.close()
print("\nFees of Student Accepted Successfully !")
#5--MODULE TO SEARCH BY NAME
def SearchByName(name):
x=0
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
cursor.execute("SELECT * FROM STUDENTS")
for i in cursor:
if i[1]==name:
x=1
print ("ADMISSION NO. IS :",i[0])
print ("NAME IS :",i[1])
print ("CLASS IS :",i[2])
print ("SECTION IS :",i[3])
print ("ROLL NO IS :",i[4])
print ("FATHER'S NAME IS :",i[5])
print ("MOTHER'S NAME IS :",i[6])
print ("CONTACT NO IS :",i[7])
print ("ADDRESS IS :",i[8])
print ("GENDER IS :",i[9])
print ("CATEGORY IS :",i[10])
if x==0:
print("RECORD DOESN'T EXIST")
return x
#6--MODULE TO SEARCH BY ADMISSION NUMBER
def SearchByAdno(no):
x=0
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
cursor.execute("SELECT * FROM STUDENTS")
for i in cursor:
if int(i[0])==no:
x=1
print ("ADMISSION NO. IS :",i[0])
print ("NAME IS :",i[1])
print ("CLASS IS :",i[2])
print ("SECTION IS :",i[3])
print ("ROLL NO IS :",i[4])
print ("FATHER'S NAME IS :",i[5])
print ("MOTHER'S NAME IS :",i[6])
print ("CONTACT NO IS :",i[7])
print ("ADDRESS IS :",i[8])
print ("GENDER IS :",i[9])
print ("CATEGORY IS :",i[10])
break
if x==0:
print("RECORD DOESN'T EXIST")
return x
#7--MODULE TO DELETE A RECORD
def Delete(no):
x=SearchByAdno(no)
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
if x == 1:
query="DELETE FROM STUDENTS WHERE sadmission_no=%s"%(no)
cursor.execute(query)
print("RECORD DELETED SUCCESSFULLY")
db.commit()
x='y'
while x=='y' or x=='Y':
print(" W E L C O M E T O S T U D E N T M A N A G E M E N T ")
print("")
print("\n---------------------------------- M E N U ----------------------------------")
print ('\n PRESS-1 : FOR NEW ADMISSION')
print ('\n PRESS-2 : TO SHOW ALL RECORDS')
print ('\n PRESS-3 : TO UPDATE STUDENT DATA')
print ('\n PRESS-4 : TO ENTER FEES OF STUDENT')
print ('\n PRESS-5 : TO SEARCH BY NAME')
print ('\n PRESS-6 : TO SEARCH BY ADNO')
print ('\n PRESS-7 : TO DELETE A RECORD')
print ('\n PRESS-0 : TO EXIT')
CH= int(input("ENTER YOUR CHOICE: "))
if CH==1:
newstudent()
elif CH==2:
displayStudent()
elif CH==3:
updateStudent()
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
elif CH==4:
feeStudent ()
elif CH==5:
name= input("Enter the name of student: ")
SearchByName(name)
elif CH==6:
no = int(input("Enter the admission no. of student: "))
SearchByAdno(no)
elif CH==7:
no = int(input("Enter the admission no. of student: "))
Delete(no)
elif CH==0:
break
else:
pass
x=input("DO YOU WANT TO CONTINUE ? (y/n)")
print("------------------------------H A V E A N I C E D A Y--------------------------")
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
OUTPUTS:
MAIN SCREEN
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
#1--MODULE FOR NEW ADMISSION
IN SQL
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
#2--MODULE TO DISPLAY STUDENT'S DATA
IN MYSQL
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
#3--MODULE TO UPDATE STUDENT'S RECORD
BEFORE:
AFTER:
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
#4--MODULE TO ENTER FEES OF THE STUDENTS
IN MYSQL
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
#5--MODULE TO SEARCH BY NAME
IN MYSQL
#6--MODULE TO SEARCH BY ADMISSION NUMBER
IN MYSQL
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
#7--MODULE TO DELETE A RECORD
IN MYSQL
BEFORE :
AFTER :
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
BIBLIOGRAPHY
The project has been completed by the
information from the following sources: -
INFORMATICS PRACTICES
SUMITA ARORA
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
lOMoARcPSD|29312395
Downloaded by Bhavesh Sharma (imninja202@gmail.com)
