PM SHRI KENDRIYA VIDYALAYA

BERHAMPUR(ODISHA)

PROJECT WORK
COMPUTER SCIENCE
CLASS XII (2023-24)

Name: Omm Swarup

Roll no: 26
Topic: JEE Questions Management
System
 INDEX
Sl Contents Page
No number
.
1 Acknowledgement 3
2 Certificate 4
3 Hardwares and Softwares 5
Required
4 Materials required 5
5 Introduction 6
6 Python Source Code 7-41
7 MySQL Database 42-55
8 Outputs 56-74
15 References 75
Acknowledgement
I would like to extend my sincere and heartfelt
obligation towards all those who have helped me in
making this project. Without their active guidance,
help, cooperation and encouragement, I would not
have been able to present the project on time.

I am extremely thankful and pay my sincere

gratitude to my teacher Mr. S.K Mishra for her
valuable guidance and support for completion this
project.

I extend my sincere gratitude to my Principal Mr.

Shivapriya Dash for the moral support extended
during tenure of this project.

I also acknowledge with a deep sense of reverence,

my gratitude towards my parents, other faculty
members of the school and friends for their valuable
suggestions given to me in completing the project.

Name Signature
 Certificate
This is to certify that the project work
titled JEE Questions Management
System is the bonafide work of Omm
Swarup of Class XII A of PM SHRI
Kendriya Vidyalaya Berhampur as a
part of Computer Science Project work
for class XII AISSCE,2023-24.

The above mentioned project work has

been completed under my guidance
during the academic year 2023-2024.

Signature of Internal Signature of External

Signature of Principal
HARDWARES AND SOFTWARES REQUIRED

HARDWARES
1. Desktop Computer / Laptop
2. Mobile Phone

SOFTWARES
1. Python (Latest Version)
2. MySQL
3. Python Connector Module
 INTRODUCTION

Welcome to the innovative world of the JEE (Joint

Entrance Examination) Question Management System,
a cutting-edge project designed to revolutionize the way
we handle and organize questions for one of the most
crucial examinations in the academic landscape. The
JEE Question Management System is an advanced
platform meticulously crafted to streamline the
creation, storage, retrieval, and analysis of JEE-related
questions.
In the realm of competitive exams, the significance of a
well-organized and efficient question management
system cannot be overstated. This project aims to
address the complexities associated with handling vast
question databases, ensuring seamless access for
educators, administrators, and students alike. By
leveraging modern technologies and user-friendly
interfaces, our system endeavors to enhance the overall
JEE examination experience, providing a robust
framework that fosters precision, accessibility, and
data-driven insights.
Join us on this journey as we embark on a mission to
transform the landscape of JEE question management,
facilitating a smoother and more effective preparation
process for aspiring students and educators.
PYTHON
SOURCE
CODE
import mysql.connector as conn

#FOR VIEWING NUMBER OF QUESTION DATA OF JEE MAIN IN THE

SUBJECT: CHEMISTRY
def JEE_Mains_Chemistry():

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
y=input("enter the year of which data is to be searched ")
if int(y)>=2013 and int(y)<=2023:

cobj.execute("select * from JEE_Mains_Chemistry where year = {}".format(y))

for data in cobj:

print("---------------------------------------------------------------")
print(" YEAR " , int(data[0]))
print(" NUMBER OF QUESTIONS ON THE FOLLOWING TOPICS ARE AS
FOLLOWS:")
print(" Physical_Chemistry " , data[1])
print(" Organic_Chemistry " , data[2])
print(" Inorganic_Chemistry " , data[3])

else:
print("///////////////////////////////////////////////////////////////////////")
print("Entered Year not in range of 2013 to 2023")
print("///////////////////////////////////////////////////////////////////////")
cobj.close()
db.close()

#FOR VIEWING NUMBER OF QUESTION DATA OF JEE MAIN IN THE

SUBJECT: PHYSICS
def JEE_Mains_Physics():

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
y=input("enter the year of which data is to be searched ")
if int(y)>=2013 and int(y)<=2023:

cobj.execute("select * from JEE_Mains_Physics where year = {}".format(y))

for data in cobj:
 print("---------------------------------------------------------------")
print(" YEAR " , int(data[0]))
print(" NUMBER OF QUESTIONS ON THE FOLLOWING TOPICS ARE AS
FOLLOWS:")
print(" Mechanics " , data[1])
print(" SHM_and_Waves " , data[2])
print(" Thermodynamics " , data[3])
print(" Gravitation " , data[4])
print(" Electrodynamics " , data[5])
print(" Currrent_and_Magnetism " , data[6])
print(" Optics " , data[7])
print(" Modern_Physics " , data[8])
print(" Semi_conductors_and_logic_Gates " , data[9])
else:
print("///////////////////////////////////////////////////////////////////////")
print("Entered Year not in range of 2013 to 2023")
print("///////////////////////////////////////////////////////////////////////")
cobj.close()
db.close()

#FOR VIEWING NUMBER OF QUESTION DATA OF JEE MAIN IN THE

SUBJECT: MATHEMATICS
def JEE_Mains_Maths():

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
y=input("enter the year of which data is to be searched ")
if int(y)>=2013 and int(y)<=2023:
cobj.execute("select * from JEE_Mains_Maths where year = {}".format(y))
for data in cobj:
print("---------------------------------------------------------------")
print(" YEAR " , int(data[0]))
print(" NUMBER OF QUESTIONS ON THE FOLLOWING TOPICS ARE AS
FOLLOWS:")
print(" Basic_Mathematics " , data[1])
print(" Trignometry_and_Inverse_trignometry " , data[2])
print(" Sequence_and_series " , data[3])
print(" quadratic_Equations " , data[4])
print(" Complex_numbers " , data[5])
print(" Binomial_and_Permutations_and_Combinations " , data[6])
print(" Coordinate_Geometry " , data[7])
print(" Determinant_Matrices " , data[8])
print(" Relations_Functions " , data[9])
 print(" Limits_Continuity_Differentiability " , data[10])
print(" AOD " , data[11])
print(" Integration " , data[12])
print(" Differential_Equations " , data[13])
print(" 3D_Geometry " , data[14])
print(" Probability " , data[15])
else:
print("///////////////////////////////////////////////////////////////////////")
print("Entered Year not in range of 2013 to 2023")
print("///////////////////////////////////////////////////////////////////////")
cobj.close()
db.close()

#FOR VIEWING NUMBER OF QUESTION DATA OF JEE ADVANCED IN

THE SUBJECT: CHEMISTRY
def JEE_Advanced_Chemistry():

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
y=input("enter the year of which data is to be searched ")
if int(y)>=2013 and int(y)<=2023:
cobj.execute("select * from JEE_Advanced_Chemistry where year = {}".format(y))
for data in cobj:

print("---------------------------------------------------------------")
print(" YEAR " , int(data[0]))
print(" NUMBER OF QUESTIONS ON THE FOLLOWING TOPICS ARE AS
FOLLOWS:")
print(" Physical_Chemistry " , data[1])
print(" Organic_Chemistry " , data[2])
print(" Inorganic_Chemistry " , data[3])

else:
print("///////////////////////////////////////////////////////////////////////")
print("Entered Year not in range of 2013 to 2023")
print("///////////////////////////////////////////////////////////////////////")
cobj.close()
db.close()

#FOR VIEWING NUMBER OF QUESTION DATA OF JEE ADVANCED IN

THE SUBJECT: PHYSICS
def JEE_Advanced_Physics():
db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
y=input("enter the year of which data is to be searched ")
if int(y)>=2013 and int(y)<=2023:

cobj.execute("select * from JEE_Advanced_Physics where year = {}".format(y))

for data in cobj:
print("---------------------------------------------------------------")
print(" YEAR " , int(data[0]))
print(" NUMBER OF QUESTIONS ON THE FOLLOWING TOPICS ARE AS
FOLLOWS:")
print(" Mechanics " , data[1])
print(" SHM_and_Waves " , data[2])
print(" Thermodynamics " , data[3])
print(" Gravitation " , data[4])
print(" Electrodynamics " , data[5])
print(" Currrent_and_Magnetism " , data[6])
print(" Optics " , data[7])
print(" Modern_Physics " , data[8])
else:
print("///////////////////////////////////////////////////////////////////////")
print("Entered Year not in range of 2013 to 2023")
print("///////////////////////////////////////////////////////////////////////")
cobj.close()
db.close()

#FOR VIEWING NUMBER OF QUESTION DATA OF JEE ADVANCED IN

THE SUBJECT: MATHEMATICS
def JEE_Advanced_Maths():

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
y=input("enter the year of which data is to be searched ")
if int(y)>=2013 and int(y)<=2023:

cobj.execute("select * from JEE_Advanced_Maths where year = {}".format(y))

for data in cobj:
print("----------------------------------------------------------------")
print(" YEAR " , int(data[0]))
 print(" NUMBER OF QUESTIONS ON THE FOLLOWING TOPICS ARE AS
FOLLOWS:")
print(" Basic_Mathematics " , data[1])
print(" Trignometry_and_Inverse_trignometry " , data[2])
print(" Sequence_and_series " , data[3])
print(" quadratic_Equations " , data[4])
print(" Complex_numbers " , data[5])
print(" Binomial_and_Permutations_and_Combinations " , data[6])
print(" Coordinate_Geometry " , data[7])
print(" Determinant_Matrices " , data[8])
print(" Relations_Functions " , data[9])
print(" Limits_Continuity_Differentiability " , data[10])
print(" AOD " , data[11])
print(" Integration " , data[12])
print(" Differential_Equations " , data[13])
print(" 3D_Geometry " , data[14])
print(" Probability " , data[15])
else:
print("///////////////////////////////////////////////////////////////////////")
print("Entered Year not in range of 2013 to 2023")
print("///////////////////////////////////////////////////////////////////////")
cobj.close()
db.close()

#TO UPDATE THE NUMBER OF QUESTIONS IN JEE ADVANCED DATA

OF THE SUCJECT: CHEMISTRY
def update_JEE_Advanced_Chem():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
topic=input("enter the topic in which question number is to be updated")
new_number=int(input("enter the updated number of questions"))
year=int(input("enter year of the which questions number is to be updated"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="update JEE_Advanced_Chemistry set {}={} where
year={}".format(topic,new_number,year)
cobj.execute(qr)
db.commit()
#TO UPDATE THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF
THE SUCJECT: CHEMISTRY
def update_JEE_Mains_Chem():
print("-------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
topic=input("enter the topic in which question number is to be updated")
new_number=int(input("enter the updated number of questions"))
year=int(input("enter year of the which questions number is to be updated"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="update JEE_Mains_Chemistry set {}={} where year={}".format(topic,new_number,year)
cobj.execute(qr)
db.commit()

#TO UPDATE THE NUMBER OF QUESTIONS IN JEE ADVANCED DATA

OF THE SUCJECT: PHYSICS
def update_JEE_Advanced_Physics():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Modern_Physics ")
print(" Semi_conductors_and_logic_Gates ")
topic=input("enter the topic in which question number is to be updated")
new_number=int(input("enter the updated number of questions"))
year=int(input("enter year of the which questions number is to be updated"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="update JEE_Advanced_Physics set {}={} where
year={}".format(topic,new_number,year)
cobj.execute(qr)
db.commit()
#TO UPDATE THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF
THE SUCJECT: PHYSICS
def update_JEE_Mains_Physics():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Modern_Physics ")
topic=input("enter the topic in which question number is to be updated")
new_number=int(input("enter the updated number of questions"))
year=int(input("enter year of the which questions number is to be updated"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="update JEE_Mains_Physics set {}={} where year={}".format(topic,new_number,year)
cobj.execute(qr)
db.commit()

#TO UPDATE THE NUMBER OF QUESTIONS IN JEE ADVANCED DATA

OF THE SUCJECT: MATHEMATICS
def update_JEE_Advanced_Maths():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
topic=input("enter the topic in which question number is to be updated")
 new_number=int(input("enter the updated number of questions"))
year=int(input("enter year of the which questions number is to be updated"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="update JEE_Advanced_Maths set {}={} where year={}".format(topic,new_number,year)
cobj.execute(qr)
db.commit()

#TO UPDATE THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF

THE SUCJECT: MATHEMATICS
def update_JEE_Mains_Maths():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
topic=input("enter the topic in which question number is to be updated")
new_number=int(input("enter the updated number of questions"))
year=int(input("enter year of the which questions number is to be updated"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="update JEE_Mains_Maths set {}={} where year={}".format(topic,new_number,year)
cobj.execute(qr)
db.commit()

#TO UPDATE THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF

THE SUCJECT: MATHEMATICS
def add_JEE_Advanced_Chem():
 print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
new_number1=int(input("enter the number of questions in Physical Chemistry"))
new_number2=int(input("enter the number of questions in Organic Chemistry"))
new_number3=int(input("enter the number of Inorganic Chemistry"))
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into JEE_Advanced_Chemistry
values({},{},{},{})".format(year,new_number1,new_number2,new_number3)
cobj.execute(qr)
db.commit()

#TO ADD THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF THE

SUCJECT: CHEMISTRY
def add_JEE_Mains_Chem():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
new_number1=int(input("enter the number of questions in Physical Chemistry"))
new_number2=int(input("enter the number of questions in Organic Chemistry"))
new_number3=int(input("enter the number of Inorganic Chemistry"))
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into JEE_Mains_Chemistry
values({},{},{},{})".format(year,new_number1,new_number2,new_number3)
cobj.execute(qr)
db.commit()

#TO ADD THE NUMBER OF QUESTIONS IN JEE ADVANCED DATA OF

THE SUCJECT: PHYSICS
def add_JEE_Advanced_Physics():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
 print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Modern_Physics ")
new_number1=int(input("enter the number of questions in Mechanics"))
new_number2=int(input("enter the number of questions in SHM_and_Waves"))
new_number3=int(input("enter the number of questions in Thermodynamics"))
new_number4=int(input("enter the number of questions in Gravitation"))
new_number5=int(input("enter the number of questions in Electrodynamics"))
new_number6=int(input("enter the number of questions in Currrent_and_Magnetism"))
new_number7=int(input("enter the number of questions in Optics"))
new_number8=int(input("enter the number of questions in Modern_Physics"))
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into JEE_Advanced_Physics
values({},{},{},{},{},{},{},{},{})".format(year,new_number1,new_number2,new_number3,ne
w_number4,new_number5,new_number6,new_number7,new_number8)
cobj.execute(qr)
db.commit()

#TO ADD THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF THE

SUCJECT: PHYSICS
def add_JEE_Mains_Physics():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Modern_Physics ")
print(" Semi_conductors_and_logic_Gates ")
new_number1=int(input("enter the number of questions in Mechanics"))
new_number2=int(input("enter the number of questions in SHM_and_Waves"))
new_number3=int(input("enter the number of questions in Thermodynamics"))
new_number4=int(input("enter the number of questions in Gravitation"))
 new_number5=int(input("enter the number of questions in Electrodynamics"))
new_number6=int(input("enter the number of questions in Currrent_and_Magnetism"))
new_number7=int(input("enter the number of questions in Optics"))
new_number8=int(input("enter the number of questions in Modern_Physics"))
new_number9=int(input("enter the number of questions in
Semi_Conductors_and_Logic_gates"))
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into JEE_Mains_Physics
values({},{},{},{},{},{},{},{},{},{})".format(year,new_number1,new_number2,new_number3,
new_number4,new_number5,new_number6,new_number7,new_number8,new_number9)
cobj.execute(qr)
db.commit()

#TO ADD THE NUMBER OF QUESTIONS IN JEE ADVANCED DATA OF

THE SUCJECT: MATHEMATICS
def add_JEE_Advanced_Maths():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
new_number1=int(input("enter the number of questions in Basic_Mathematics"))
new_number2=int(input("enter the number of questions in
Trignometry_and_Inverse_trignometry"))
new_number3=int(input("enter the number of questions in Sequence_and_series"))
new_number4=int(input("enter the number of questions in quadratic_Equations"))
new_number5=int(input("enter the number of questions in Complex_numbers"))
new_number6=int(input("enter the number of questions in
Binomial_and_Permutations_and_Combinations"))
 new_number7=int(input("enter the number of questions in Coordinate_Geometry"))
new_number8=int(input("enter the number of questions in Determinant_Matrices"))
new_number9=int(input("enter the number of questions in
Limits_Continuity_Differentiability"))
new_number10=int(input("enter the number of questions in AOD"))
new_number11=int(input("enter the number of questions in Integration"))
new_number12=int(input("enter the number of questions in Differential_Equations"))
new_number13=int(input("enter the number of questions in 3D_Geometry"))
new_number14=int(input("enter the number of questions in Probability"))
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into JEE_Advanced_Maths
values({},{},{},{},{},{},{},{},{},{},{},{},{},{},{})".format(year,new_number1,new_number2,
new_number3,new_number4,new_number5,new_number6,new_number7,new_number8,new_nu
mber9,new_number10,new_number11,new_number12,new_number13,new_number14)
cobj.execute(qr)
db.commit()

#TO ADD THE NUMBER OF QUESTIONS IN JEE MAINS DATA OF THE

SUCJECT: MATHEMATICS
def add_JEE_Mains_Maths():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
new_number1=int(input("enter the number of questions in Basic_Mathematics"))
new_number2=int(input("enter the number of questions in
Trignometry_and_Inverse_trignometry"))
new_number3=int(input("enter the number of questions in Sequence_and_series"))
 new_number4=int(input("enter the number of questions in quadratic_Equations"))
new_number5=int(input("enter the number of questions in Complex_numbers"))
new_number6=int(input("enter the number of questions in
Binomial_and_Permutations_and_Combinations"))
new_number7=int(input("enter the number of questions in Coordinate_Geometry"))
new_number8=int(input("enter the number of questions in Determinant_Matrices"))
new_number9=int(input("enter the number of questions in
Limits_Continuity_Differentiability"))
new_number10=int(input("enter the number of questions in AOD"))
new_number11=int(input("enter the number of questions in Integration"))
new_number12=int(input("enter the number of questions in Differential_Equations"))
new_number13=int(input("enter the number of questions in 3D_Geometry"))
new_number14=int(input("enter the number of questions in Probability"))
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into JEE_Mains_Maths
values({},{},{},{},{},{},{},{},{},{},{},{},{},{},{})".format(year,new_number1,new_number2,
new_number3,new_number4,new_number5,new_number6,new_number7,new_number8,new_nu
mber9,new_number10,new_number11,new_number12,new_number13,new_number14)
cobj.execute(qr)
db.commit()

#TO ADD AN IMPOTANT QUESTION OF THE SUCJECT: CHEMISTRY

INTO JEE ADVANCED QUESTIONS DATA
def add_question_JEE_Advanced_Chem():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
topic=input("enter the topic in which question is to be entered")
question=input("enter the question")
year=int(input("enter year in which question was asked is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into jee_advanced_chemistry_important_questions
values({},'{}','{}')".format(year,topic,question)
cobj.execute(qr)
db.commit()
#TO ADD AN IMPOTANT QUESTION OF THE SUCJECT: CHEMISTRY
INTO JEE MAINS QUESTIONS DATA
def add_question_JEE_Mains_Chem():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
topic=input("enter the topic in which question is to be entered")
question=input("enter the question")
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into jee_mains_chemistry_important_questions
values({},'{}','{}')".format(year,topic,question)
cobj.execute(qr)

#TO ADD AN IMPOTANT QUESTION OF THE SUCJECT: PHYSICS INTO JEE

ADVANCED QUESTIONS DATA
def add_question_JEE_Advanced_Physics():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Modern_Physics ")
topic=input("enter the topic in which question is to be entered")
question=input("enter the question")
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into jee_advanced_physics_important_questions
values({},'{}','{}')".format(year,topic,question)
cobj.execute(qr)
#TO ADD AN IMPOTANT QUESTION OF THE SUCJECT: PHYSICS INTO JEE MAINS
QUESTIONS DATA
def add_question_JEE_Mains_Physics():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Modern_Physics ")
print(" Semi_conductors_and_logic_Gates ")
topic=input("enter the topic in which question is to be entered")
question=input("enter the question")
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into jee_mains_physics_important_questions
values({},'{}','{}')".format(year,topic,question)
cobj.execute(qr)

#TO ADD AN IMPOTANT QUESTION OF THE SUCJECT: MATHEMATICS

INTO JEE ADVANCED QUESTIONS DATA
def add_question_JEE_Advanced_Maths():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
 print(" Probability ")
topic=input("enter the topic in which question is to be entered")
question=input("enter the question")
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into jee_advanced_maths_important_questions
values({},'{}','{}')".format(year,topic,question)
cobj.execute(qr)

#TO ADD AN IMPOTANT QUESTION OF THE SUCJECT: MATHEMATICS

INTO JEE ADVANCED QUESTIONS DATA
def add_question_JEE_Mains_Maths():
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
topic=input("enter the topic in which question is to be entered")
question=input("enter the question")
year=int(input("enter year in which questions number is to be entered"))

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="insert into jee_mains_maths_important_questions
values({},'{}','{}')".format(year,topic,question)
cobj.execute(qr)
#TO VIEW THE IMPORTANT QUESTIONS ASKED EACH YEAR IN JEE
MAINS OF THE SUBJECT: CHEMISTRY
def Importnat_Questions_JEE_Mains_Chemistry():

print("Enter 1 to enter the topic whose important questions is to be searched")

print("Enter 2 to view the complete data")
c=int(input("Enter your choice"))
if c==1:

print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
topic=input("Enter the topic to be searched")
if topic in "Physical_Chemistry Organic_Chemistry Inorganic_Chemistry":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Mains_Chemistry_Important_Questions where
topic='{}'".format(topic)
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if topic not in "Physical_Chemistry Organic_Chemistry Inorganic_Chemistry":

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

if c==2:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Mains_Chemistry_Important_Questions"
 cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if c<1 or c>2:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS
NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

#TO VIEW THE IMPORTANT QUESTIONS ASKED EACH YEAR IN JEE

ADVANCED OF THE SUBJECT: CHEMISTRY
def Importnat_Questions_JEE_Advanced_Chemistry():

print("Enter 1 to enter the topic whose important questions is to be searched")

print("Enter 2 to view the complete data")
c=int(input("Enter your choice"))
if c==1:
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
topic=input("Enter the topic to be searched")
if topic in "Physical_Chemistry Organic_Chemistry Inorganic_Chemistry":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from jee_advanced_chemistry_important_questions where
topic='{}'".format(topic)
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if topic not in "Physical_Chemistry Organic_Chemistry Inorganic_Chemistry":

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

if c==2:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Advanced_Chemistry_Important_Questions"
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if c<1 or c>2:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS
NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

#TO VIEW THE IMPORTANT QUESTIONS ASKED EACH YEAR IN JEE

ADVANCED OF THE SUBJECT: PHYSICS
def Importnat_Questions_JEE_Advanced_Physics():

print("Enter 1 to enter the topic whose important questions is to be searched")

print("Enter 2 to view the complete data")
c=int(input("Enter your choice"))
if c==1:
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
 print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
topic=input("Enter the topic to be searched")
if topic in " Mechanics SHM_and_Waves Thermodynamics Gravitation Electrodynamics
Currrent_and_Magnetism Optics ":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Advanced_Physics_Important_Questions where
topic='{}'".format(topic)
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , topic)
print("Question" , data[2])

if topic not in " Mechanics SHM_and_Waves Thermodynamics Gravitation

Electrodynamics Currrent_and_Magnetism Optics ":

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

if c==2:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Advanced_Physics_Important_Questions"
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if c<1 or c>2:
print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS
NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

#TO VIEW THE IMPORTANT QUESTIONS ASKED EACH YEAR IN JEE

MAINS OF THE SUBJECT: PHYSICS
def Importnat_Questions_JEE_Mains_Physics():
print("Enter 1 to enter the topic whose important questions is to be searched")
print("Enter 2 to view the complete data")
c=int(input("Enter your choice"))
if c==1:
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Mechanics ")
print(" SHM_and_Waves ")
print(" Thermodynamics ")
print(" Gravitation ")
print(" Electrodynamics ")
print(" Currrent_and_Magnetism ")
print(" Optics ")
print(" Semi_conductors_and_logic_Gates ")
topic=input("Enter the topic to be searched")
if topic in " Mechanics SHM_and_Waves Thermodynamics Gravitation
Electrodynamics Currrent_and_Magnetism Optics Semi_conductors_and_logic_Gates":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Mains_Physics_Important_Questions where
topic='{}'".format(topic)
cobj.execute(qr)
print("Year" , data[0])
print("Topic" , topic)
print("Question" , data[2])

if topic not in " Mechanics SHM_and_Waves Thermodynamics Gravitation

Electrodynamics Currrent_and_Magnetism Optics Semi_conductors_and_logic_Gates":
print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

if c==2:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Mains_Physics_Important_Questions"
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if c<1 or c>2:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS
NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

#TO VIEW THE IMPORTANT QUESTIONS ASKED EACH YEAR IN JEE

MAINS OF THE SUBJECT: MATHEMATICS
def Importnat_Questions_JEE_Mains_Maths():

print("Enter 1 to enter the topic whose important questions is to be searched")

print("Enter 2 to view the complete data")
c=int(input("Enter your choice"))
if c==1:
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
 print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
topic=input("Enter the topic to be searched")
if topic in "Basic_Mathematics Trignometry_and_Inverse_trignometry
Sequence_and_series quadratic_Equations Complex_numbers
Binomial_and_Permutations_and_Combinations Coordinate_Geometry Determinant_Matrices
Relations_Functions Limits_Continuity_Differentiability AOD Integration
Differential_Equations 3D_Geometry Probability":

db=conn.onnect(host="localhost",user="root",database="JEE",password="OmmHappy@10605"
)
cobj=db.cursor()
qr="Select * from JEE_Mains_Maths_Important_Questions where
topic='{}'".format(topic)
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , topic)
print("Question" , data[2])
if topic not in "Basic_Mathematics Trignometry_and_Inverse_trignometry
Sequence_and_series quadratic_Equations Complex_numbers
Binomial_and_Permutations_and_Combinations Coordinate_Geometry Determinant_Matrices
Relations_Functions Limits_Continuity_Differentiability AOD Integration
Differential_Equations 3D_Geometry Probability":

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")
print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

if c==2:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Mains_Maths_Important_Questions"
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if c<1 or c>2:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS
NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

#TO VIEW THE IMPORTANT QUESTIONS ASKED EACH YEAR IN JEE

ADVANCED OF THE SUBJECT: MATHEMATICS
def Importnat_Questions_JEE_Advanced_Maths():

print("Enter 1 to enter the topic whose important questions is to be searched")

print("Enter 2 to view the complete data")
c=int(input("Enter your choice"))
if c==1:
print("------------------------------------------------------------------")
print(" AVAILABLE TOPICS ")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
 print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability ")
print(" AOD ")
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability ")
topic=input("Enter the topic to be searched")
if topic in "Basic_Mathematics Trignometry_and_Inverse_trignometry
Sequence_and_series quadratic_Equations Complex_numbers
Binomial_and_Permutations_and_Combinations Coordinate_Geometry Determinant_Matrices
Relations_Functions Limits_Continuity_Differentiability AOD Integration
Differential_Equations 3D_Geometry Probability":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Advanced_Maths_Important_Questions where
topic='{}'".format(topic)
cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , topic)
print("Question" , data[2])

if topic not in "Basic_Mathematics Trignometry_and_Inverse_trignometry

Sequence_and_series quadratic_Equations Complex_numbers
Binomial_and_Permutations_and_Combinations Coordinate_Geometry Determinant_Matrices
Relations_Functions Limits_Continuity_Differentiability AOD Integration
Differential_Equations 3D_Geometry Probability":

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

if c==2:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
qr="Select * from JEE_Advanced_Maths_Important_Questions"
 cobj.execute(qr)
for data in cobj:
print("Year" , data[0])
print("Topic" , data[1])
print("Question" , data[2])

if c<1 or c>2:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS
NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////")

#TO TRANSFER CONTROL TO ADMIN ON SUCCESSFUL VEFICATION

def admin():
print("*********************************************************************")
print("Welcome Admin to JEE_Questions_DATA from 2013-2023")
print("*********************************************************************")
print("Enter 1 for updating the number of questions ")
print("Enter 2 for updating the importnat questions ")
inpu=int(input("Enter your choice "))
if inpu==1:
print("enter 1 for updating number of questions in Chemistry in JEE Advanced data")
print("enter 2 for updating number of questions in Chemistry in JEE Mains data")
print("enter 3 for updating number of questions in Physics in JEE Advanced data")
print("enter 4 for updating number of questions in Physics in JEE Mains data")
print("enter 5 for updating number of questions in Maths in JEE Advanced data")
print("enter 6 for updating number of questions in Maths in JEE Mains data")
print("enter 7 for addig new data to Chemistry in JEE Advanced data")
print("enter 8 for addig new data to Chemistry in JEE Mains data")
print("enter 9 for addig new data to Physics in JEE Advanced data")
print("enter 10 for addig new data to Physics in JEE Mains data")
print("enter 11 for addig new data to Maths in JEE Advanced data")
print("enter 12 for addig new data to Maths in JEE Mains data")
choice=int(input("enter your choice"))
if choice==1:
update_JEE_Advanced_Chem()
if choice==2:
update_JEE_Mains_Chem()
if choice==3:
update_JEE_Advanced_Physics()
 if choice==4:
update_JEE_Mains_Physics()
if choice==5:
update_JEE_Advanced_Maths()
if choice==6:
update_JEE_Mains_Maths()
if choice==7:
add_JEE_Advanced_Chem()
if choice==8:
add_JEE_Mains_Chem()
if choice==9:
add_JEE_Advanced_Physics()
if choice==10:
add_JEE_Mains_Physics()
if choice==11:
add_JEE_Advanced_Maths()
if choice==12:
add_JEE_Mains_Maths()
if inpu==2:
print("enter 1 for adding the important questions of Chemistry in JEE Advanced data")
print("enter 2 for adding the important questions of Chemistry in JEE Mains data")
print("enter 3 for adding the important questions of Physics in JEE Advanced data")
print("enter 4 for adding the important questions of Physics in JEE Mains data")
print("enter 5 for adding the important questions of Maths in JEE Advanced data")
print("enter 6 for adding the important questions of Maths in JEE Mains data")
choice=int(input("Enter your choice"))
if choice==1:
add_question_JEE_Advanced_Chem()
if choice==2:
add_question_JEE_Mains_Chem()
if choice==3:
add_question_JEE_Advanced_Physics()
if choice==4:
add_question_JEE_Mains_Physics()
if choice==5:
add_question_JEE_Advanced_Maths()
if choice==6:
add_question_JEE_Mains_Maths()

#WELCOME MESSAGE
print("*************************************************************")
print("Welcome to JEE_Questions_DATA from 2013-2023")
print("*************************************************************")
print("For Admin enter 1 ")
print("For User enter 2 ")
inp=int(input("Enter your choice "))

if inp==1:
print("Enter username")
user=input("")
print("Enter password")
pasw=input("")

dbo=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@1060
5")
cu=dbo.cursor()
query="select * from admin_data"
cu.execute(query)
for data in cu:
if data[0]==user and data[1]==pasw:
admin()

else:
print("WRONG PASSWORD OR USERNAME")

#TO TRANSFER CONTROL TO USER

if inp==2:
print("*********************************************************************")
print("Welcome User to JEE_Questions_DATA from 2013-2023")
print("*********************************************************************")
print("enter 1 for JEE_mains_questions data")
print("enter 2 for JEE_Advanced_questions data")
print("enter 3 for selection of topic_wise data from chemistry")
print("enter 4 for selection of topic_wise data from physics")
print("enter 5 for selection of topic_wise data from maths")
print("enter 6 for viewing important questions of JEE Advanced")
print("enter 7 for viewing important questions of JEE Mains")
x=int(input("Enter your choice "))

if x==1:

print("************************************************************************
***************")
print("Welcome to JEE_MAINS_Number_of_Questions DATA from 2013-2023")

print("************************************************************************
***************")
print("enter 1 for JEE_mains_Chemistry data")
 print("enter 2 for JEE_mains_Physics data")
print("enter 3 for JEE_mains_Maths data")
z=int(input("Enter your choice "))
if z==1:
JEE_Mains_Chemistry()
if z==2:
JEE_Mains_Physics()
if z==3:
JEE_Mains_Maths()
if z<=0 or z>=4:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")

if x==2:

print("************************************************************************
*****")
print("Welcome to JEE_ADVANCED_Number_of_Questions DATA from 2013-2023")

print("************************************************************************
*****")
print("enter 1 for JEE_Advanced_Chemistry data")
print("enter 2 for JEE_Advanced_Physics data")
print("enter 3 for JEE_Advanced_Maths data")
z=int(input("Enter your choice"))
if z==1:
JEE_Advanced_Chemistry()
if z==2:
JEE_Advanced_Physics()
if z==3:
JEE_Advanced_Maths()
if z<=0 or z>=4:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
 print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")

if x==3:

print("************************************************************************
*****")
print("Welcome to Chemistry_Topicwise_data of JEE from 2013-2023")

print("************************************************************************
*****")
print(" AVAILABLE TOPICS ")
print(" Physical_Chemistry ")
print(" Organic_Chemistry ")
print(" Inorganic_Chemistry ")
q=input("enter the topic whose data you want to see ")
if q in ["Physical_Chemistry" , "Organic_Chemistry" , "Inorganic_Chemistry"]:

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
cobj1=db.cursor()
print("------------------JEE_Adavanced_Data----------------------")
cobj.execute("select {},year from JEE_Advanced_Chemistry".format(q))
for data in cobj:
print("Year" , data[1])
print("Number of Questions from" , q , "is", data[0])
print("----------------JEE_Mains_Data----------------------")
cobj1.execute("select {},year from JEE_Mains_Chemistry".format(q))
for data1 in cobj1:
print("Year" , data1[1])
print("Number of Questions from" , q , "is", data1[0])

if q not in ["Physical_Chemistry", "Organic_Chemistry", "Inorganic_Chemistry"]:

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")
 if x==4:

print("************************************************************************
*****")
print("Welcome to Physics_Topicwise_data of JEE from 2013-2023")

print("************************************************************************
*****")
print(" AVAILABLE TOPICS ")
print(" Mechanics " )
print(" SHM_and_Waves " )
print(" Thermodynamics " )
print(" Gravitation " )
print(" Electrodynamics " )
print(" Currrent_and_Magnetism ")
print(" Optics " )
print(" Modern_Physics " )
print(" Semi_conductors_and_logic_Gates ")
q =input("enter the topic whose data you want to see ")
if q in "Mechanics SHM_and_Waves Thermodynamics Gravitation Electrodynamics
Currrent_and_Magnetism Optics Modern_Physics Semi_conductors_and_logic_Gates":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
cobj1=db.cursor()
print("------------------JEE_Adavanced_Data----------------------")
cobj.execute("select {},year from JEE_Advanced_Physics".format(q))
for data in cobj:
print("Year" , data[1])
print("Number of Questions from" , q , "is", data[0])
print("-----------------------JEE_Mains_Data-------------------------")
cobj1.execute("select {},year from JEE_Mains_Physics".format(q))
for data1 in cobj1:
print("Year" , data[1])
print("Number of Questions from" , q , "is", data[0])
if q not in "Mechanics SHM_and_Waves Thermodynamics Gravitation Electrodynamics
Currrent_and_Magnetism Optics Modern_Physics Semi_conductors_and_logic_Gates":

print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH
IS NOT AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")
print("//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////")

if x==5:

print("************************************************************************
*****")
print("Welcome to Maths_Topicwise_data of JEE from 2013-2023")

print("************************************************************************
*****")
print(" Basic_Mathematics ")
print(" Trignometry_and_Inverse_trignometry ")
print(" Sequence_and_series ")
print(" quadratic_Equations ")
print(" Complex_numbers ")
print(" Binomial_and_Permutations_and_Combinations ")
print(" Coordinate_Geometry ")
print(" Determinant_Matrices ")
print(" Relations_Functions ")
print(" Limits_Continuity_Differentiability " )
print(" AOD " )
print(" Integration ")
print(" Differential_Equations ")
print(" 3D_Geometry ")
print(" Probability " )
q =input("enter the topic whose data you want to see ")
if q in "Basic_Mathematics Trignometry_and_Inverse_trignometry Sequence_and_series
quadratic_Equations Complex_numbers Binomial_and_Permutations_and_Combinations
Coordinate_Geometry Determinant_Matrices Relations_Functions
Limits_Continuity_Differentiability AOD Integration Differential_Equations 3D_Geometry
Probability":

db=conn.connect(host="localhost",user="root",database="JEE",password="OmmHappy@10605
")
cobj=db.cursor()
cobj1=db.cursor()
print("------------------JEE_Adavanced_Data----------------------")
cobj.execute("select {},year from JEE_Advanced_Maths".format(q))
for data in cobj:
print("Year" , data[1])
print("Number of Questions from" , q , "is", data[0])
print("-----------------------JEE_Mains_Data--------------------------")
 cobj1.execute("select {},year from JEE_Mains_Maths".format(q))
for data1 in cobj1:
print("Year" , data1[1])
print("Number of Questions from" , q , "is", data1[0])
if q not in "Basic_Mathematics Trignometry_and_Inverse_trignometry Sequence_and_series
quadratic_Equations Complex_numbers Binomial_and_Permutations_and_Combinations
Coordinate_Geometry Determinant_Matrices Relations_Functions Limits_Continuity_Differentiability
AOD Integration Differential_Equations 3D_Geometry Probability":

print("///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS NOT
AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////")

if x==6:

print("*******************************************************************************
***************************")
print("Welcome to Topicwise_Importnat_Questions_of_JEE_Advanced of JEE from 2013-2023")

print("*******************************************************************************
***************************")
print("Enter 1 for viewing important question of Chemistry")
print("Enter 2 for viewing important question of Physics")
print("Enter 3 for viewing important question of Maths")
z1=int(input("Enter your choice"))
if z1==1:
Importnat_Questions_JEE_Advanced_Chemistry()
if z1==2:
Importnat_Questions_JEE_Advanced_Physics()
if z1==3:
Importnat_Questions_JEE_Advanced_Maths()
if z1<1 or z1>3:

print("///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS NOT
AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////")

if x==7:

print("*******************************************************************************
***************************")
 print("Welcome to Topicwise_Importnat_Questions_of_JEE_Mains of JEE from 2013-2023")

print("*******************************************************************************
***************************")
print("Enter 1 for viewing important question of Chemistry")
print("Enter 2 for viewing important question of Physics")
print("Enter 3 for viewing important question of Maths")
z2=int(input("Enter your choice"))

if z2==1:
Importnat_Questions_JEE_Mains_Chemistry()
if z2==2:
Importnat_Questions_JEE_Mains_Physics()
if z2==3:
Importnat_Questions_JEE_Mains_Maths()
if z2<1 or z2>3:

print("///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS NOT
AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")

print("///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////")

if x<1 or x>7:
print("/////////////////////////////////////////////////////////////////////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS NOT
AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")
print("////////////////////////////////////////////////////////////////////////////////////////")

if inp<1 or inp>2:
print("/////////////////////////////////////////////////////////////////////////////////////////")
print("YOU CHOSE A WRONG OPTION OR WROTE THE WRONG TOPIC WHICH IS NOT
AVAILABLE")
print("PLEASE ENTER YOUR CHOICE CAREFULLY")
print("////////////////////////////////////////////////////////////////////////////////////////")

print("****************************************************")
print("THANK YOU FOR USING THE PROGRAM")
print("****************************************************")

#AT THE END OF EACH FUNCTION EXCEPTION IS HANDLED EFFICIENTLY

#EVERY DATA IS BEING DISPLAYED USING THE FOR LOOP MECHANISM
 MYSQL
DATABASE
Tables in JEE database

Admin data table

JEE Advanced Chemistry number of questions Table

JEE Advanced Chemistry Important Questions Table

JEE Advanced Maths number of questions Table
JEE Advanced Maths Important Questions Table
JEE Advanced Physics number of questions Table
JEE Advanced Physics Important Questions Table
JEE Mains Chemistry number of questions Table
JEE Mains Chemistry Important questions Table
JEE Mains Maths number of questions Table
JEE Mains Maths Important question Table
JEE Mains Physics number of questions Table
JEE Mains Physics Important question Table
OUTPUTS
Starting of program

Admin Authentication
Entering Choice
Entering the data to be inserted to number of
question data
Entering the data to be updated to number of
question data
Selecting Choice

Entering the data to be inserted to Important

question data
JEE Questions Data

JEE Mains Questions Data

Searching chemistry data

Searching Physics data

Searching Maths data

JEE Advanced Questions data

Searching Chemistry data

Searching Physics data

Searching Maths data

Topicwise Chemistry data search

Searching Chemistry Data
Topicwise Physics data search

Entering the Topic

Topicwise Maths data search

Entering Topic
Topicwise Important Questions JEE Advanced data
search

Selecting Choice

Selecting Choice
For Choice 1

For Choice 2
Topicwise Important Questions JEE Mains data
search

Selecting Choice

Selecting Choice

For Choice 1
For Choice 2

Exception Handling
 REFERENCES

1. Wikipedia
https://www.wikipedia.org/

2. Python
https://www.python.org/

3. MySQL
https://www.mysql.com/

4. 11th and 12th Computer

Science Arihant Books