DAV PUBLIC SCHOOL , SEC-7 ,ROHINI

DELHI-110085

SUBMITTED BY – ANSHIKA DIXIT

CLASS – XII-B
ROLL NO.- 11
PROJECT NAME – EVENT MANAGEMENT
 INDEX

➢ Aim
➢ Certificate
➢ Introduction
➢ Codes
➢ Output
➢ Modules Used
➢ Bibliography

AIM
❖The main aim of this project is to let the students
apply their programming skills into real world
situation/problem and give them greater
opportunity to go into greater detail of how
management system of some particular types of
shops work.

❖ This project also aims to give the students more

experience about how these skills helps in
developing a good programmer.
 CERTIFICATE

This is to certify that Anshika Dixit and Akshara Bhardwaj of class XII-
B have completed their project titled “Management system of an
Event” under the guidance of Mrs. Shalu Ghose for the academic year
2024-2025. The certified students have been dedicated throughout
the completion of their work before the given d eadline without
missing any important details from the project. It also certifies that
this project is teamwork of all the students and can be submitted for
evaluation.
Teacher’s Signature:

INTRODUCTION

The Event Management System is a computer science

project that utilizes pymysql, a Python library for
MySQL database management, to revolutionize library
retail operations. By replacing manual processes and
leveraging technology, this system offers a streamlined
approach to managing inventory, tracking customers,
processing sales, and generating reports. With a user-
friendly interface, the system ensures efficient data
storage and retrieval, reducing errors and improving
overall efficiency. The project aims to enhance
customer experience, boost business growth, and
provide valuable insights for decision-making. The
Event Management System powered by pymysql is set
to transform the pet retail industry through automation
and options

CODES...

import pymysql

import tabulate

# Creating a database

db1 = pymysql.connect(host='localhost',user='root',password='tanu092006')

cur=db1.cursor()

cur.execute('create database if not exists Event_mgmt;')

# Creation of Table-Events
db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

cur.execute("drop table Events")

cur.execute("create table if not exists Events(Event_id int(5),Event_name

varchar(50),Event_date date,Event_location varchar(20),Event_description varchar(100));")

cur.execute("alter table Events modify event_name varchar(50)")

cur.execute("insert into
Events(event_id,event_name,event_date,event_location,event_description)values(1,'Codi
ng Bootcamp','2024-10-26','New Delhi,India','Learn to code from scratch');")

cur.execute("insert into Events values(2,'Data science workshop','2024-11-

09','Bangalore,India','Master the fundamentals of data science');")

cur.execute("insert into Events values(3,'Social media marketting conference','2024-11-

15','Mumbai,India','Learn strategies to grow your social media presence');")

cur.execute("insert into Events values(4,'Product design masterclass','2024-12-

07','Chennai,India','Become a pro in product design thinking');")

cur.execute("insert into Events values(5,'Public speaking workshop','2025-01-

18','Hyderabad,India','Develop your public speaking skills');")

cur.execute("insert into Events values(6,'Web development for beginners','2025-02-

01','Pune,India','Build your first website');")

cur.execute("insert into Events values(7,'SEO optimizing training','2025-02-

22','Kolkata,India','Improve your website ranking');")

cur.execute("insert into Events values(8,'Content marketting strategies','2025-03-

08','Ahmedabad,India','Learn to create engaging content');")

cur.execute("insert into Events values(9,'Growth hacking fundamentals','2025-03-

29','Jaipur,India','Discover growth hacking techniques');")
cur.execute("insert into Events values(10,'App development for enterpreneurs','2025-04-
19','Chandigarh,India','Learn to build your own mobile app');")

db1.commit()

# Creation of Table-Attendees

cur.execute("drop table Attendees")

cur.execute("Create table if not exists Attendees(Attendee_id int(2),attendee_name

varchar(30),attendee_email varchar(50),attendee_phone varchar(20));")

cur.execute("insert into Attendees values(1,'Jhon Doe','john.doe@example.com','+91

1234567890');")

cur.execute("insert into Attendees values(2,'Jane smith','jane.smith@example.com','+91

9876543210');")

cur.execute("insert into Attendees values(3,'Michael

Brown','michael.brown@example.com','+91 876543210');")

cur.execute("insert into Attendees values(4,'Alice

Williams','alice.williams@example.com','+91 7654321089');")

cur.execute("insert into Attendees values(5,'David

Miller','david.miller@example.com','+91 6543210789');")

cur.execute("insert into Attendees values(6,'Sarah

Jonas','sarah.jonas@example.com','+91 5432106789');")

cur.execute("insert into Attendees values(7,'Ollivia

Garcia','ollivia.garcia@example.com','+91 4321056789');")

cur.execute("insert into Attendees values(8,'Noah

Jackson','noah.jackson@example.com','+91 3210456789');")

cur.execute("insert into Attendees values(9,'Emily

Hernandez','emily.hernandez@example.com','+91 2103456789');")
cur.execute("insert into Attendees values(10,'Sophia
Devis','sophia.devis@example.com','+91 1023456789');")

db1.commit()

# Creation of Table-Registrations

cur.execute("drop table registrations")

cur.execute("Create table if not exists registrations(registration_id int(5),event_id

int(5),attendee_id int(5),registration_date date);")

cur.execute("insert into registrations values(1,1,1,'2024-09-20')")

cur.execute("insert into registrations values(2,2,2,'2024-10-02')")

cur.execute("insert into registrations values(3,1,3,'2024-09-25')")

cur.execute("insert into registrations values(4,3,4,'2024-10-10')")

cur.execute("insert into registrations values(5,2,5,'2024-10-04')")

cur.execute("insert into registrations values(6,1,6,'2024-09-30')")

cur.execute("insert into registrations values(7,4,7,'2024-11-12')")

cur.execute("insert into registrations values(8,2,8,'2024-10-16')")

cur.execute("insert into registrations values(9,3,9,'2024-10-18')")

cur.execute("insert into registrations values(10,5,10,'2025-01-10')")

db1.commit()
# Creation of Table-Event_Staff

cur.execute("drop table Event_Staff")

cur.execute("create table if not exists Event_staff(staff_id int(5),staff_name

varchar(20),staff_role varchar(50),staff_contact varchar(20));")

cur.execute("insert into event_staff values(1,'Riya Sharma','Event Coordinator','+91

1234567890')")

cur.execute("insert into event_staff values(2,'Rohan Patel','Registration Staff','+91

9876543212')")

cur.execute("insert into event_staff values(3,'Priya Singh','AV Technician','+91

8765432193')")

cur.execute("insert into event_staff values(4,'Akash Malhotra','Security Guard','+91

7654321098')")

cur.execute("insert into event_staff values(5,'Nikita Kapoor','Caterer','+91 6543210780')")

cur.execute("insert into event_staff values(6,'Shreya Mehta','Usher','+91 5432109877')")

cur.execute("insert into event_staff values(7,'Aditya Rao','Stagehand','+91 4321098766')")

cur.execute("insert into event_staff values(8,'Disha Iyer','Marketing Assistant','+91

3210987655')")

cur.execute("insert into event_staff values(9,'Mihir Joshi','Photographer','+91

2109876544')")

cur.execute("insert into event_staff values(10,'Shaurya Kumar','Videographer','+91

1098765433')")

db1.commit()

# Function to insert a row in the table-Events...

def insertEvents():

db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

while True:

a=int(input("Enter Event id number : "))

b=input("Enter Event name : ")

c=input("Enter Event date : ")

d=input("Enter Event location : ")

e=input("Enter Event description : ")

query="insert into Events values(%s,%s,%s,%s,%s)"

cur.execute(query,(a,b,c,d,e))

print ("record inserted successfully")

db1.commit()

restart= input("Do you want to insert another row? (y/n) : ")

if restart=='y':

pass

elif restart=='n':

break

else:

print("value unacceptable")

print("exiting")
 break

# Function to insert a row in the table-Attendees...

def insertAttendees():

db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

while True:

a=int(input("Enter Attendee id number : "))

b=input("Enter Attendee Name : ")

c=input("Enter Attendee Email Address : ")

d=int(input("Enter Attendee Phone no. : "))

query="insert into Attendees values(%s,%s,%s,%s)"

cur.execute(query,(a,b,c,d))

print("record inserted successfully")

db1.commit()

restart=input("Do you want to insert another row? (y/n) : ")

if restart=='y':

pass
 elif restart=='n':

break

else:

print("value unacceptable")

print("exiting")

break

# Function to insert a row in the table-Registrations...

def insertRegistrations():

db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

while True:

a=int(input("Enter Registration id number : "))

b=int(input("Enter Event id number : "))

c=int(input("Enter Attendee id number : "))

d=input("Enter Registration date : ")

query="insert into Registrations values(%s,%s,%s,%s)"

cur.execute(query,(a,b,c,d))

print("record inserted successfully")

 db1.commit()

restart=input("Do you want to insert another row? (y/n) : ")

if restart=='y':

pass

elif restart=='n':

break

else:

print("value unacceptable")

print("exiting")

break

# Function to insert a row in the table-Event_Staff...

def insertEventStaff():

db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

while True:

a=int(input("Enter Staff id number : "))

b=input("Enter Staff Name : ")

 c=input("Enter Staff Role : ")

d=int(input("Enter Staff Contact no. : "))

query="insert into Event_Staff values(%s,%s,%s,%s)"

cur.execute(query,(a,b,c,d))

print("record inserted succesfully")

db1.commit()

restart=input("Do you want to insert another row? (y/n): ")

if restart=='y':

pass

elif restart=='n':

break

else:

print("value unacceptable")

print("exiting")

break

# Function to delete a row from the table

def delete(tname,fname,value):
db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

if type(value)is str:

cur.execute(f" Delete from {tname} where {fname}='{value}'")

else:

cur.execute(f" Delete from {tname} where {fname}= {value}")

db1.commit()

print("deleted")

# Function for searching a record...

def search(tname,fname,value):

db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

if type(value)is str:

cur.execute(f" select * from {tname} where {fname}='{value}'")

else:
 cur.execute(f" select * from {tname} where {fname}={value}")

print(tabulate.tabulate(cur.fetchall(),headers=[str(d[0])for d in cur.description]))

# Function to modify a record...

def modify(tname,fname,old_value,new_value):

db1=pymysql.connect(host='localhost',user='root',password='tanu092006',db='Event_mg
mt')

cur=db1.cursor()

if type(old_value) is str:

cur.execute(f" update {tname} set {fname}='{new_value}' where {fname}=

'{old_value}'")

else:

cur.execute(f" update {tname} set {fname}={new_value} where {fname}=

{old_value}")

db1.commit()

print("modified")
# Menu...

while True:

print('''Which table would you like to manage ?

1.Events

2.Attendees

3.Registrations

4.Event_Staff''')

a=int(input("Enter here : "))

while True:

if a==1:

print("""what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row""")

b=int(input("Enter your choice : "))

if b==1:

cur.execute("select * from Events")

 print(tabulate.tabulate(cur.fetchall(),headers=[str(d[0])for d in
cur.description]))

elif b==2:

insertEvents()

elif b==3:

c=int(input("Enter Event id which you want to delete : "))

Events='Events'

Event_id='Event_id'

delete('Events','Event_id',c)

elif b==4:

c=input("Enter field name which is to be updated : ")

Events='Events'

Event_id='Event_id'

d=int(input("Enter old value : "))

e=int(input("Enter new value : "))

modify(Events,c,d,e)

elif b==5:

c=int(input("Enter Event id which you want to search : "))

Events='Events'

Event_id='Event_id'

search(Events,Event_id,c)

elif a==2:

print("""what do you want to do?

 1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row""")

b=int(input("Enter your choice : "))

if b==1:

cur.execute("select * from Attendees")

print(tabulate.tabulate(cur.fetchall(),headers=[str(d[0])for d in
cur.description]))

elif b==2:

insertAttendees()

elif b==3:

c=int(input("Enter Attendee id which you want to delete : "))

Attendees='Attendees'

Attendee_id='Attendee_id'

delete('Attendees','Attendee_id',c)

elif b==4:

c=input("Enter field name which is to be updated : ")

Attendees='Attendees'

Attendee_id='Attendee_id'

d=int(input("Enter old value : "))

e=int(input("Enter new value : "))

 modify(Attendees,c,d,e)

elif b==5:

c=int(input("Enter Attendee id which you want to search : "))

Attendees='Attendees'

Attendee_id='Attendee_id'

search(Attendees,Attendee_id,c)

elif a==3:

print("""What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row""")

b=int(input("Enter your choice : "))

if b==1:

cur.execute("select * from Registrations")

print(tabulate.tabulate(cur.fetchall(),headers=[str(d[0])for d in
cur.description]))

elif b==2:

insertRegistrations()

elif b==3:
 c=int(input("Enter Registration id which you want to delete : "))

Registrations='Registrations'

Registration_id='Registration_id'

delete('Registrations','Registration_id',c)

elif b==4:

c=input("Enter field name which is to be updated : ")

Registrations='Registrations'

Registration_id='Registration_id'

d=int(input("Enter old value : "))

e=int(input("Enter new value : "))

modify(Registrations,c,d,e)

elif b==5:

c=int(input("Enter Registration id which you want to search : "))

Registrations='Registrations'

Registration_id='Registration_id'

search(Registrations,Registration_id,c)

elif a==4:

print("""What do you want to do?

1.Display the table

2.Add a new record

 3.Delete an old record

4.Update a record

5.Search a particular row""")

b=int(input("Enter your choice : "))

if b==1:

cur.execute("select * from Event_Staff")

print(tabulate.tabulate(cur.fetchall(),headers=[str(d[0])for d in
cur.description]))

elif b==2:

insertEventStaff()

elif b==3:

c=int(input("Enter Staff id which you want to delete : "))

Event_Staff='Event_Staff'

Staff_id='Staff_id'

delete('Event_Staff','Staff_id',c)

elif b==4:

c=input("Enter field name which is to be updated : ")

Event_Staff='Event_Staff'

Staff_id='Staff_id'

d=int(input("Enter old value : "))

e=int(input("Enter new value : "))

 modify(Event_Staff,c,d,e)

elif b==5:

c=int(input("Enter Staff id which you want to search : "))

Event_Staff='Event_Staff'

Staff_id='Staff_id'

search(Event_Staff,Staff_id,c)

restart=input("Do you want to perform again? (y/n): ")

if restart=='y':

pass

elif restart=='n':

break

else:

print("value unacceptable")

print("exiting")

break

restart=input("would you like to switch to another table? (y/n): ")

if restart=='y':

pass

elif restart=='n':

break

else:
print("value unacceptable")

print("exiting")

break
 OUTPUT...
Which table would you like to manage ?

1.Events

2.Attendees

3.Registrations

4.Event_Staff

Enter here : 1

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 1

Event_id event_name Event_date Event_location Event_description

---------- ---------------------------------- ------------ ---------------- -------------------------------------------------

--

1 Coding Bootcamp 2024-10-26 New Delhi,India Learn to code from scratch

2 Data science workshop 2024-11-09 Bangalore,India Master the fundamentals

of data science

3 Social media marketting conference 2024-11-15 Mumbai,India Learn strategies to

grow your social media presence

4 Product design masterclass 2024-12-07 Chennai,India Become a pro in product

design thinking
 5 Public speaking workshop 2025-01-18 Hyderabad,India Develop your public
speaking skills

6 Web development for beginners 2025-02-01 Pune,India Build your first website

7 SEO optimizing training 2025-02-22 Kolkata,India Improve your website

ranking

8 Content marketting strategies 2025-03-08 Ahmedabad,India Learn to create

engaging content

9 Growth hacking fundamentals 2025-03-29 Jaipur,India Discover growth hacking

techniques

10 App development for enterpreneurs 2025-04-19 Chandigarh,India Learn to build

your own mobile app

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 2

Enter Event id number : 11

Enter Event name : Farewell

Enter Event date : 2025-06-02

Enter Event location : Rohini

Enter Event description : DAV Public school

record inserted successfully

Do you want to insert another row? (y/n) : n

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 3

Enter Event id which you want to delete : 1

deleted

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 4

Enter field name which is to be updated : Event_id

Enter old value : 2

Enter new value : 12

modified

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

 3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 5

Enter Event id which you want to search : 7

Event_id event_name Event_date Event_location Event_description

---------- ----------------------- ------------ ---------------- ----------------------------

7 SEO optimizing training 2025-02-22 Kolkata,India Improve your website ranking

Techniques

Which table would you like to manage ?

1.Events

2.Attendees

3.Registrations

4.Event_Staff

Enter here : 2

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 1

Attendee_id attendee_name attendee_email attendee_phone

------------- --------------- --------------------------- ----------------

1 Jhon Doe john.doe@example.com +91 1234567890

 2 Jane smith jane.smith@example.com +91 9876543210

3 Michael Brown michael.brown@example.com +91 876543210

4 Alice Williams alice.williams@example.com +91 7654321089

5 David Miller david.miller@example.com +91 6543210789

6 Sarah Jonas sarah.jonas@example.com +91 5432106789

7 Ollivia Garcia ollivia.garcia@example.com +91 4321056789

8 Noah Jackson noah.jackson@example.com +91 3210456789

9 Emily Hernandez emily.hernandez@example.com +91 2103456789

10 Sophia Devis sophia.devis@example.com +91 1023456789

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 2

Enter Attendee id number : 11

Enter Attendee Name : Dixit

Enter Attendee Email Address : dixit@gmail.com

Enter Attendee Phone no. : 1234567654

record inserted successfully

Do you want to insert another row? (y/n) : n

Do you want to perform again? (y/n): y

what do you want to do?

 1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 3

Enter Attendee id which you want to delete : 3

deleted

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 4

Enter field name which is to be updated : Attendee_id

Enter old value : 1

Enter new value : 11

modified

Do you want to perform again? (y/n): y

what do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

 4.Update a record

5.Search a particular row

Enter your choice : 5

Enter Attendee id which you want to search : 5

Attendee_id attendee_name attendee_email attendee_phone

------------- --------------- ------------------------ ----------------

5 David Miller david.miller@example.com +91 6543210789

Do you want to perform again? (y/n): n

would you like to switch to another table? (y/n): y

Python 3.12.4 (tags/v3.12.4:8e8a4ba, Jun 6 2024, 19:30:16) [MSC v.1940 64 bit (AMD64)] on
win32

Type "help", "copyright", "credits" or "license()" for more information.

= RESTART: C:\Users\dixit\AppData\Local\Programs\Python\Python312\event_mgmt.py

Which table would you like to manage ?

1.Events

2.Attendees

3.Registrations

4.Event_Staff

Enter here : 3

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record
 5.Search a particular row

Enter your choice : 1

registration_id event_id attendee_id registration_date

----------------- ---------- ------------- -------------------

1 1 1 2024-09-20

2 2 2 2024-10-02

3 1 3 2024-09-25

4 3 4 2024-10-10

5 2 5 2024-10-04

6 1 6 2024-09-30

7 4 7 2024-11-12

8 2 8 2024-10-16

9 3 9 2024-10-18

10 5 10 2025-01-10

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 2

Enter Registration id number : 11

Enter Event id number : 6

Enter Attendee id number : 11

Enter Registration date : 2024-07-06

record inserted successfully

Do you want to insert another row? (y/n) : n

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 3

Enter Registration id which you want to delete : 10

deleted

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 4

Enter field name which is to be updated : registration_id

Enter old value : 6

Enter new value : 16

modified
Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 5

Enter Registration id which you want to search : 1

registration_id event_id attendee_id registration_date

----------------- ---------- ------------- -------------------

1 1 1 2024-09-20

Do you want to perform again? (y/n): n

would you like to switch to another table? (y/n): y

Which table would you like to manage ?

1.Events

2.Attendees

3.Registrations

4.Event_Staff

Enter here : 4

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record
 5.Search a particular row

Enter your choice : 1

staff_id staff_name staff_role staff_contact

---------- -------------- ------------------- ---------------

1 Riya Sharma Event Coordinator +91 1234567890

2 Rohan Patel Registration Staff +91 9876543212

3 Priya Singh AV Technician +91 8765432193

4 Akash Malhotra Security Guard +91 7654321098

5 Nikita Kapoor Caterer +91 6543210780

6 Shreya Mehta Usher +91 5432109877

7 Aditya Rao Stagehand +91 4321098766

8 Disha Iyer Marketing Assistant +91 3210987655

9 Mihir Joshi Photographer +91 2109876544

10 Shaurya Kumar Videographer +91 1098765433

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 2

Enter Staff id number : 11

Enter Staff Name : disha parmar

Enter Staff Role : Event_manager

Enter Staff Contact no. : 9878978654

record inserted succesfully

Do you want to insert another row? (y/n): n

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 3

Enter Staff id which you want to delete : 11

deleted

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter here : 4

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

 4.Update a record

5.Search a particular row

Enter your choice : 4

Enter field name which is to be updated : staff_id

Enter old value : 1

Enter new value : 11

modified

Do you want to perform again? (y/n): y

What do you want to do?

1.Display the table

2.Add a new record

3.Delete an old record

4.Update a record

5.Search a particular row

Enter your choice : 5

Enter Staff id which you want to search : 4

staff_id staff_name staff_role staff_contact

---------- -------------- -------------- ---------------

4 Akash Malhotra Security Guard +91 7654321098

Do you want to perform again? (y/n): n

would you like to switch to another table? (y/n): n

Exiting...

MODULES USED
 • PYMYSQL
• TABULATE

BIBLIOGRAPHY

Sources used for gathering information:

1. Class notes – for basic code

2. www.google.com – for searching some websites for help

3. www.youtube.com – for learning more about python MySQL interface