SHRI MAHAPRABHU PUBLIC SCHOOL

SHRI NARAYAN ASHRAM SHIVKUTI TELIYARGANJ PRAYAGRAJ-211004

Computer Science Project

On

“EVENT MANAGEMENT SYSTEM”

Submitted to partial fulfilment of the requirements for
ALL INDIA SENIOR SECONDARY CERTIFICATE EXAMINATION -2024

ROLL NO :
NAME : Vaibhav Pandey
CLASS : XII – A 1
SUBJECT : COMPUTER SCIENCE
SUB CODE : 083
PROJECT GUIDE :- Mr ANKIT PRABHAKAR PGT (CS)
SHRI MAHARPRABHU PUBLIC SCHOOL
 SHRI MAHAPRABHU PUBLIC SCHOOL
CERTIFICATE

This is to certify that Master Vaibhav Pandey Roll No: ***** has successfully
completed the project Work entitled “EVENT MANAGEMENT SYSTEM” in the
subject Computer Science (083) laid down in the regulations of CBSE for the
purpose of Practical Examination in Class XII to be held in SHRI MAHAPRABHU
PUBLIC SCHOOL 2024. This report or identical report on this topic has not been
submitted for any other examination and does not form a part of any other
course undergone by the candidate.

(ANKIT PRABHAKAR)
PGT (Comp. Science)

(DR RAVINDER PAL KAUR BIRDIE)

PRINCIPAL

Examiner Name:
Signature:
 TABLE OF CONTENTS(TOC)

SERIAL NUMBER DESCRIPTION PAGE NUMBER

01 Acknowledgement

02 Introduction

03 Objectives of the
project
04 Source Code

05 Output

06 Hardware and Software

Requirements
07 Bibliography
 ACKNOWLEDGEMENT

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

MR ANKIT PRABHAKAR PGT (CS) as well as our principal

MRS RAVINDER BIRDIE who gave me golden opportunity to do this

project of Computer Science, which also helped me in doing a lot of

research and I came to know new things about it. Without their help,

guidance and support it would be impossible to complete this

project. Secondly, I would also like to thank my parents and friends

who helped me a lot in finishing this project within limited time. I am

making this project not only for marks but also to increase my

knowledge. Once again thanks to all who helped me in doing this

project.
 EVENT MANAGEMENT SYSYTEM

INTRODUCTION :
This Event Management System project is a comprehensive application developed using
Python and MySQL to efficiently manage events. It serves as a database-driven system that
allows users to perform CRUD operations (Create, Read, Update, Delete) on event records
through a command-line interface.
Key Features:
1. Database Setup and Connection:
o Automatically creates and connects to the EventManagement database.
o Ensures the Events table is set up with fields like EventID, EventName, Date,
Time, Location, and Description.
2. Add Event:
o Allows users to input event details such as name, date, time, location, and
description to store in the database.
3. View Events:
o Displays all stored events with details in a readable format.
4. Update Event:
o Provides functionality to modify an event's details by specifying its unique
EventID.
5. Delete Event:
o Deletes a specific event by its EventID.
6. Search Events:
o Users can search for events using either the event's name (partial search) or
the event date.
7. List Upcoming Events:
o Lists all events in chronological order by date.
8. Count Total Events:
 o Displays the total number of events stored in the system.
9. Clear All Events:
o Option to delete all events with a confirmation prompt.
10. User-Friendly Interface:
o Menu-driven navigation for ease of use, allowing users to select from various
operations interactively.
Purpose and Use Case:
This system is designed to streamline event management processes for small organizations,
clubs, or personal use, making it easy to track and organize event details. It demonstrates
practical integration of Python with MySQL, highlighting skills in database handling, SQL
queries, and interactive console programming.
 MODULES AND FUNCTIONS

Modules Used:

1. mysql.connector:

o A MySQL database connector for Python that allows interaction with MySQL
databases.

Functions Defined in the Code:

1. connect_to_db():

o Connects to the MySQL database EventManagement and returns the connection

object.

2. setup_database():

o Creates the EventManagement database and Events table if they do not already
exist.

3. add_event():

o Adds a new event to the Events table by prompting the user for event details.

4. view_events():

o Displays all events stored in the Events table.

5. update_event():

o Updates the details of an existing event based on the EventID.

6. delete_event():

o Deletes an event from the Events table based on the EventID.

7. search_events():

o Searches for events by event name or date and displays matching results.

8. list_upcoming_events():

o Lists all events ordered by date in ascending order.

9. count_events():

o Counts the total number of events in the Events table.

10. clear_events():

o Deletes all events from the Events table after user confirmation.
11. main():

o Displays the menu and allows the user to choose which function to execute based on
input.
FLOW OF PROJECT
SOURCE CODE
OUTPUT
 HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE

• PERSONAL COMPUTER
• MOBILE PHONE

Software

• Python 3.10.2
• MySQL
• Python Connector
 BIBLIOGRAPHY

• Books:-

1. Preeti Arora Computer Science book for class 12th

2. NCERT Computer Science for class 12th

• Websites:-

1. www.google.com
2. www.wikipedia.com
THANK YOU