HARIOM!

VGN CHINMAYA VIDYALAYA (CBSE)

AVADI, CHENNAI –71

CLASS XII

ACADEMIC SESSION:

COMPUTER SCIENCE PROJECT

TITLE: “VENUE BOOKINGS AND EVENT

MANAGEMENT SYSTEM”

Submitted by

___________
__________

XII – Science

1
EXAM ROLL NO
 VGN CHINMAYA VIDYALAYA
(Sekkadu Main Road, Sekkadu, Avadi, Chennai – 600 071)

BONAFIDE CERTIFICATE

This is to certify that …………………………………of class XII has

performed the Computer science project titled

……………………………………………………………………………………

……………………………………………………………………………………

at VGN CHINMAYA VIDYALAYA, AVADI during the academic year 20---

20--.

Submitted for Practical Exam held on …………………………….. at

VGN CHINMAYA VIDYALAYA, AVADI.

Teacher in-charge

Signature of Principal Signature of External Examiner

2
 INDEX
[Link] Title Page No
1. Acknowledgement 4
2. Introduction 5

Objective of the Project 6

3.
4. Why Python and MySQL?
7
5. Module Description 9
6. User defined functions 10
7. Software and hardware 11
requirements
8. Source code
12
9. Database used in SQL 22
10. Output
24
11. Future scope of the Project
29
12. Bibliography
30

3
 ACKNOWLEDGEMENT

I would like to express my sincere gratitude towards my project

guide and Computer Science teacher, Sri. [Link] for guiding
me throughout the making of this project. His valuable advice helped
me immensely in the successful completion of this project. I would
also like to thank our school principal, [Link], for her
coordination in extending every possible support.

4
 INTRODUCTION

The Venue Bookings and Event Management is a modern solution

proposed to simplify the real-life process of organizing and reserving
venues for events such as weddings, seminars, parties, etc., . In the
traditional approach, venue bookings are often made manually
through calls or in-person visits. This system enhances venue
bookings by providing a computer-based platform that allows
administrators, customers, and venue owners to interact efficiently.
Built using Python and MySQL, it ensures smooth data handling,
quick record retrieval, and secure storage of details related to
venues, customers, and events—all in one place.

By modernizing the way bookings are managed, this system brings

convenience and accuracy to both service providers and customers.
Users can easily check available venues, view their capacity and
ambiance, and make bookings on specific dates without confusion.
Venue owners can manage prices or update their listings instantly,
while administrators can monitor all activity in real time. In essence,
this project mirrors how digital automation in real-life industries
improves efficiency, reduces manual workload, and promotes
transparency in business operations, making it a practical step
toward smart event management.

5
 OBJECTIVE OF THE PROJECT

The main objective of the Venue Bookings and Event Management

System is to provide a digital solution that simplifies the real-life
process of booking event venues, reducing paperwork and improving
communication between service providers and clients.
o To automate the traditionally manual and time consuming
venue booking process, making it faster and more reliable.
o To build a computer-based platform where administrators,
customers, and venue owners can manage all booking activities
efficiently.
o To enable customers to quickly check available venues, view
essential details such as capacity and price, and make seamless
bookings without conflicts.
o To allow venue owners to efficiently manage pricing, update
venue details, and remove past events, improving operational
efficiency.
o To help administrators maintain transparency and control over
all bookings and customer records, minimizing confusion and
duplications.

6
WHAT IS PYTHON:
Python is a high-level, interpreted programming language that is widely used
for software development, data analysis, automation, web development, and
many other applications. It was created by Guido van Rossum and first released
in 1991. Python is known for its simple syntax, readability, and versatility,
making it an ideal language for beginners as well as professional developers.
Key Features of Python:
1. Easy to Learn and Read: Python has a clean and straightforward syntax that
resembles English, which makes coding easier.
2. Interpreted Language: Python code is executed line by line, allowing quick
testing and debugging.
3. Cross-Platform: Python programs can run on Windows, Mac, Linux, and
other operating systems without modification.
4. Large Standard Library: Python comes with many built-in modules and
packages for tasks like file handling, database interaction, and web
development.
5. Object-Oriented and Procedural Support: Python supports multiple
programming paradigms, including object-oriented and procedural
programming.
6. Open Source and Community Support: Python is free to use and has a large
global community that contributes tools, libraries, and frameworks.
In this project, Python is used to create the venue bookings and event
management system because of its simplicity, powerful libraries, and ability to
connect easily with databases like MySQL.

7
WHAT IS SQL:-
SQL, which stands for Structured Query Language, is a standard
programming language designed for managing and manipulating
relational databases. It is widely used in software development, data
analysis, and web applications to handle large amounts of structured data
efficiently. SQL allows users to create, modify, and manage databases and
tables, as well as insert, update, delete, and retrieve data in an organized
manner.
Key Features of SQL:
1. Data Management: SQL provides commands to create databases and
tables, define relationships between data, and maintain data integrity.
2. Data Retrieval: Using the SELECT statement, SQL can query databases
to extract specific information, even from large datasets.
3. Data Manipulation: SQL supports operations like INSERT, UPDATE, and
DELETE to modify the database content.
4. Data Security: SQL allows defining user roles and permissions to control
access and protect sensitive data.
5. Standardized Language: SQL is supported by almost all relational
database systems, including MySQL, Oracle, SQL Server, and PostgreSQL.
In this project, SQL (via MySQL) is used to store and organize all user data
for the event details, customer details, venue details and venue booked
dates. This ensures that records are secure, structured, and easily
retrievable for analysis and reporting. By using SQL, the project
demonstrates the importance of databases in building functional and
efficient software applications.

8
 MODULE DESCRIPTION
This project uses several Python modules to build an integrated
Venue Booking and Event Management System. These modules
provide essential functionality, including database connectivity, date
and time handling, and user interaction.

1. [Link]
• Purpose: To connect Python programs with a MySQL database.
• Usage in Project:
o Establishes connection to the venue_bookings database.
o Performs database operations such inserting and deleting
records and fetching data.
2. datetime
• Purpose: To work with dates in Python.
• Usage in Project:
o Converts user input into proper date and time objects.

This combination of modules allows the project to efficiently handle

data, connect with databases, hence establishing a modern and
efficient venue bookings and event management system.

9
 USER DEFINED FUNCTIONS

 add_venues() – Allows the admin to add new venue details

into the venue1 table.

 view_venues() – Displays all venue records stored in the

venue1 table.

 view_customers() – Shows all customer booking details

from the customer_details table with formatted dates.

 change_price() – Enables a venue owner to update the

price of a specific venue.

 delete_old_events() – Deletes past event records (before

the current date) from the venue2 table.

 Book_event() – Lets customers view available events and

venues, choose one, and book a date; saves the booking
data into venue2 and customer_details.

 main_menu() – Acts as the main control menu that

navigates between Admin, Customer, Venue Owner
functions, or exits the system.

10
SOFTWARE AND HARDWARE REQUIREMENTS

SOFTWARES REQUIRED FOR THIS PROJECT:

 Python (version-3.11)
 MySQL (version-8.0)
 Any latest Operating System(OS)
HARDWARE REQUIRED FOR THIS PROJECT:
Any computer with
 Processor: intel®core™i3-
3217u@1.80GHZ
 Installed memory(RAM):4.00GB
 System type:64-bit operating system

11
 SOURCE CODE
import [Link]
import datetime
conn=[Link](host="localhost",user="root",
password="Pass@1234",database="venue_bookings")
cursor=[Link]()

#ADMIN
def add_venues():
ans='y'
while ans=='y':
v_name=input("enter venue name:")
v_id=int(input("enter venue ID:"))
owner=input("enter owner name:")
contactno=int(input("enter contact number:"))
ambnce=input("enter ambiance:")
cap=int(input("enter capacity:"))
address=str(input("enter address:"))
price=int(input("enter price:"))
s="""insert into
venue1(venue_id,venue_name,venue_ambiance,owner_nam
e,contact_no,capacity,Address,price)

12
values({},'{}','{}','{}',{},{},'{}',
{})""".format(v_id,v_name,ambnce,owner,contactno,cap,addr
ess,price)
[Link](s)
[Link]()
ans=input("Want to add more?(y/n)")
print("Records added successfully")

def view_venues():
s="select * from venue1"
[Link](s)
data=[Link]()
for row in data:
print(row)

def view_customers():
s="select * from customer_details"
[Link](s)
data=[Link]()
for row in data:
event_date=row[3]
formatted_date = event_date.strftime('%d-%m-%Y')

13
 print('Customer Name','Event Name','Venue
Name','Event Date','Customer [Link]','Customer E-Mail
id',sep=' | ')

print(row[0],row[1],row[2],formatted_date,row[4],row[5],sep
=" | ",end='\n\n')
#VENUE OWNERS
def change_price():
venue_name=str(input("Enter the venue name:"))
price=int(input("Enter the new price of the venue:"))
sql ="update venue1 set price={} where
venue_name='{}';".format(price,venue_name)
[Link](sql)
[Link]()
print("Price updated successfully!")

def delete_old_events():
sql="delete from venue2 where booked_date<curdate()"
[Link](sql)
[Link]()
print("Deleted the old event successfully!")
#CUSTOMERS
def Book_event():
print("The list of events are:")
[Link]("select * from event_details;")
14
 E_D=[Link]()
for row1 in E_D:
print(row1)
print("others")
E_N=input("Enter the name of the event:")
if E_N=='others' or E_N=='OTHERS' or E_N=='Others':
E_N=input("Enter the name of the event:")
ev_mange=str(input("Do you want event
managers?(yes/no)"))
if ev_mange=='yes' or ev_mange=='YES' or
ev_mange=='Yes':
event_theme=input("Enter the event theme:")
else:
event_theme='Null'
print("The list of venues are:")
[Link]("select * from venue1")
V_1=[Link]()
T=('VENUE ID','VENUE NAME','VENUE AMBIANCE','VENUE
CAPACITY','VENUE ADDRESS','VENUE RENT PRICE')
print(T)
for row2 in V_1:
t=(row2[0],row2[1],row2[2],row2[5],row2[6],row2[7])
for i in t:
print(i,end=' | ')
15
 print( )
print()
print("Please consider the following option")
print("[Link] venue")
print("[Link]")
choice=str(input("Enter the choice:"))
if choice=='1':
while True :
V_ID=int(input("Enter the venue_id of the venue:"))
V_N=input("Enter the Venue name:")
[Link]("select * from venue1 where
venue_id={}".format(V_ID))
V2_ID=[Link]()
print("The details of the venue are:")
for row3 in V2_ID:
for item in list(row3):
if [Link](item)==0:
print("Venue ID:",item)
elif [Link](item)==1:
print("Venue Name:",item)
elif [Link](item)==2:
print("Venue Ambiance:",item)
elif [Link](item)==3:

16
 print("Venue Owner Name:",item)
elif [Link](item)==4:
print("Contact Number:",item)
elif [Link](item)==5:
print("Venue capacity:",item)
elif [Link](item)==6:
print("Venue Address:",item)
else:
print("Venue rent price:",item)
[Link]("select
venue_id,venue_name,booked_date from venue2 where
venue_id={}".format(V_ID))
V3_ID=[Link]()
print("The selected venue is booked on the following
dates:")
for r in V3_ID:
venue_date=r[2]
formatted_date = venue_date.strftime('%d-%m-%Y')
print(r[0],r[1],formatted_date,sep=',',end='\n\n')
print()
ans=input("Can we proceed to venue
booking?(yes/no)")
if ans=='yes':
Name=input("Enter your name:")

17
 Date=input("Enter the date to be booked
on(yyyy,mm,dd):")
CN=int(input("Enter your [Link]:"))
E_id=input("Enter your email-id:")
V_2="""INSERT INTO
venue2(venue_id,venue_name,booked_date,event_name,cu
stomer_name)

values({},'{}','{}','{}','{}')""".format(V_ID,V_N,Date,E_N,Name)
[Link](V_2)
[Link]()
C_D="""INSERT INTO
customer_details(customer_name,event_name,venue_booke
d_name,booked_date,contact_no,email_id,event_manager,e
vent_theme)
values('{}','{}','{}','{}',
{},'{}','{}','{}')""".format(Name,E_N,V_N,Date,CN,E_id,ev_man
ge,event_theme)
[Link](C_D)
[Link]()
print("Booked Succesfully")
break
elif ans=='no':
print("consider the following options:")
print("1. Look for other venues")
print("2. exit")
18
 ch=int(input("enter your choice:"))
if ch==1:
continue
if ch==2:
break

def main_menu():
while True:
print("\n===== Venue Management & Booking System
=====")
print("1. admin")
print("2. customer")
print("3. venue owner")
print("4. Exit")
choice = input("Enter your choice: ")
if choice=='1':
#Password verification
password=str(input("enter password:"))
if password=='Pass@1234':
print("login successful")
print("[Link] new venues")
print("[Link] venue details")
print("[Link] customer details")
19
 print("[Link]")
choice=str(input("enter your choice:"))
if choice=='1':
add_venues()
elif choice=='2':
view_venues()
elif choice=='3':
view_customers()
elif choice=='4':
break
else:
print("invalid choice.......Try again")
else:
print("Incorrect password...Try again")
elif choice == '2':
print("1. book event")
print("2. exit")
choice=str(input("Enter the choice:"))
if choice=='1':
Book_event()
elif choice=='2':
break
else:

20
 print("Invalid choice.....Try again")
elif choice == '3':
print("[Link] price")
print("[Link] past events")
print("[Link]")
choice=str(input("Enter the choice:"))
if choice=='1':
change_price()
elif choice=='2':
delete_old_events()
elif choice=='3':
break
else:
print("Invalid choice.....Try again")
elif choice == '4':
break
else:
print("Invalid choice..... Try again.")
main_menu()

21
 DATABASE DETAILS
Create table venue1
(venue_id int,
venue_name varchar(30),
venue_ambiance varchar(60),
owner_name varchar(15),
contact_no bigint,
capacity int,
Address varchar(60),
price int);

Create table venue2

(venue_id int,
venue_name varchar(30),
booked_date date,
event_name varchar(20),
customer_name varchar(20));

22
Create table event_details
(event_id int,
event_name varchar(20));

Create table customer_details

(customer_name varchar(20),
event_name varchar(20),
venue_booked_name varchar(20),
booked_date date,
contact_no bigint,
email_id varchar(30)
event_manager varchar(5)
event_theme varchar(30));

OUTPUT
23
24
25
26
27
28
 FUTURE SCOPE OF THE PROJECT

The Venue Booking and Event Management can be further

enhanced and expanded in several ways to improve its
usability and efficiency. Some possible future developments
are:

o By using html we can elevate this project by transforming

this into a fully functional website.
o Online Payment Integration adding secure payment
gateways (like UPI, PayPal, or credit card options) will
allow users to complete their bookings instantly and safely.
o Notification System: Implementing automated email or
SMS alerts to notify customers and venue owners about
bookings, cancellations, or upcoming events.
o Review and Rating System: Allowing customers to provide
feedback and ratings for venues, helping future customers
make informed decisions.
o Mobile Application Development: A dedicated Android or
iOS app can make the system more accessible, allowing
users to book venues or manage events anytime,
anywhere.
o AI-Based Recommendations: Artificial Intelligence can be
used to suggest suitable venues, themes, or vendors based
on user preferences, event type, and budget.
o Virtual Tour of Venues: Using VR/AR technologies to
provide users with a 360° virtual walkthrough of venues
before booking.

29
` BIBLIOGRAPHY:

❖ CLASS 12 NCERT Computer Science book

❖ Class 12 Computer Science with Python
-Sumita Arora
❖ [Link]
❖ [Link]
❖ [Link]

30