A Course End Project Report on

ER for event management (events, venues, attendees); justify

relationships

A8517- Database Management Systems Laboratory

Submitted by

[Link]

NA 24881A05FA

Course Facilitator

[Link] begum
Assistant Professor

Department of Computer Science and Engineering

Vardhaman College of Engineering, Hyderabad

 Autonomous Institute, Affiliated to JNTUH,
Approved by AICTE, Accredited by NAAC with A+
+ Grade Kacharam, Shamshabad, Hyderabad-
501 218, Telangana, India.

DEPARTMENT OF COMPUTER SCIENCE AND

ENGINEERING

This is to certify that the Course End Project titled “Title” is carried out by
Name 1 , Name 2 and Name 3 with Roll Numbers Roll 1, Roll 2 and Roll
3 towards AXXX – Subject Laboratory course in partial fulfilment of the
requirements for the award of degree of Bachelor of Technology in
Computer Science and Engineering during the Academic year 2025-26.

Signature of the Course

Signature of the
Faculty [Link]
HOD Dr
begum
.Gagandeep
Assistant
Arora HOD, CSE
Professor, CSE
Contents

1 Introduction..........................................................................................................................3
2 Literature Review...............................................................................................................3
3 Objectives..............................................................................................................................3
4 Methodology.........................................................................................................................3
4.1 Architectural Diagram......................................................................................3
4.2 Hardware and Software Requirements...........................................................3
4.3 Working Principle...................................................................................................4
4.4 Software Implementation....................................................................................4
5 Results and Discussion....................................................................................................4
6 Mapping POs and SDGs..................................................................................................5
6.1 Program Outcomes (POs) Mapping...............................................................5
6.2 Sustainable Development Goals (SDGs) Mapping.................................5
7 Conclusion.............................................................................................................................5
Bibliography...................................................................................................................................6
 Abstract

The Event Management System is designed to simplify and improve

the process of organizing, scheduling, and managing events by
using a structured database approach based on the Entity–
Relationship (ER) model. In many organizations and institutions,
events such as conferences, workshops, seminars, and cultural
programs require proper coordination of venues, participants, and
schedules.
Traditional manual methods of managing such information often
lead to errors, data duplication, and difficulty in retrieving
records. To overcome these challenges, the proposed system
introduces a database-driven solution that efficiently stores and
manages event-related data.
The ER model plays a key role in designing the system by
identifying major entities such as Event, Venue, Attendee,
Organizer, and Registration. Each entity contains specific
attributes that describe its characteristics, and relationships are
established to show how these entities interact with each other.
For example, a venue can host multiple events, while an event
can have many attendees registered for participation. These
relationships help maintain data consistency and reduce
redundancy in the database.
The system architecture includes a user interface for organizers
and attendees, an application layer that processes event
operations, and a database layer that stores all event information
securely. Through this system, organizers can create and manage
events, assign venues, and track registrations efficiently.
Attendees can register for events and access event details easily.
Overall, the proposed Event Management System improves
efficiency, accuracy, and organization in event handling. It also
provides a scalable framework that can be expanded with
additional features such as online registration, notifications,
reporting, and analytics. This makes the system suitable for
educational institutions, organizations, and event planners.
Introduction

Event management systems are digital platforms designed to organize, schedule, and manage
events efficiently. In modern organizations, events such as conferences, workshops, cultural
programs, seminars, and exhibitions require proper planning and coordination. Managing
these activities manually can lead to errors, scheduling conflicts, and difficulties in tracking
participants and venues. Therefore, database-driven solutions are essential to streamline the
entire process.
The Event Management System is designed to store and manage information related to
events, venues, and attendees. An Entity-Relationship (ER) model is used to represent the
structure of the database and the relationships between different entities involved in event
management. The ER model helps in visualizing how data is connected and ensures efficient
data organization.
The primary entities in this system include Events, Venues, and Attendees. Events represent
the activities being organized, venues represent the locations where events take place, and
attendees represent the participants who register for the events. By creating relationships
among these entities, the system can effectively track which events are scheduled at which
venues and which attendees are participating.
This ER model improves data consistency, reduces redundancy, and supports efficient query
processing. It also helps developers understand how the system will function before
implementing the database.
 Literature Review

Several researchers and developers have studied the design and implementation
of event management systems using database models. Many existing systems rely
on relational databases to manage large amounts of event-related information.
The use of ER modeling has become a standard approach in database design
because it provides a clear and structured representation of data relationships.
Previous studies highlight that event management platforms often include
modules such as event scheduling, participant registration, venue management,
and notification systems. These modules depend heavily on the relationships
between entities such as organizers, events, venues, and attendees. Researchers
have also emphasized the importance of normalization in databases to reduce data
duplication and maintain integrity.
Some systems focus on online event registration, where attendees can sign up
through a web portal. Others include automated scheduling features that allocate
venues based on availability. The literature also suggests integrating mobile
applications and cloud-based storage to improve accessibility and scalability.
Furthermore, recent advancements include the use of analytics and artificial
intelligence to predict attendance trends and optimize event planning. These
technologies rely on well-structured databases, which are typically designed using
ER models.
Overall, the literature shows that an effective event management system must
have a well-designed database structure. The ER model plays a critical role in
ensuring that all components of the system are interconnected and function
smoothly.
 Objectives

The main objective of developing an Event Management System using an ER model

is to design a structured database that efficiently manages event-related data. This
system aims to simplify the process of organizing events and handling participant
information.
One important objective is to identify the key entities involved in the event
management process. These entities include Events, Venues, and Attendees. By
clearly defining these entities and their attributes, the system can store accurate
and meaningful data.
Another objective is to establish relationships between entities. For example, an
event must occur at a specific venue, and attendees must register for events.
These relationships help in understanding how different components interact within
the system.
The system also aims to reduce data redundancy and maintain consistency in the
database. With the help of ER modeling, duplicate information can be minimized,
and data can be organized efficiently. This ensures faster data retrieval and better
system performance.
Additionally, the system is designed to support scalability so that it can handle
multiple events and a large number of attendees. It should also allow easy updates
and modifications.
Finally, the objective is to create a clear blueprint for database implementation.
The ER model serves as a foundation for converting the design into tables and

relationships in a relational database system.

 Methodology
Architectural Diagram

Figure 1: Architectural Diagram

The architectural design of the Event Management System explains how different components
of the system interact with each other. It generally follows a layered architecture to ensure
proper communication between the user interface, application logic, and database.
The first layer is the user interface layer. This layer allows users such as event organizers and
attendees to interact with the system. Users can create events, register for events, and view
event details through a web or mobile application.
The second layer is the application layer. This layer processes user requests and performs
operations such as validating input, checking venue availability, and managing attendee
registrations. It acts as a bridge between the user interface and the database.
The third layer is the database layer. This layer stores all the information related to events,
venues, and attendees. The ER model is implemented here in the form of tables and
relationships.
This architecture ensures efficient data flow and system performance.
 Hardware and Software Requirements

To develop and run the Event Management System efficiently, certain hardware and
software requirements must be met. These requirements ensure smooth functioning
of the system and better performance during event management operations.
The hardware requirements include a computer system with a minimum of 4 GB
RAM, a modern processor, and sufficient storage space to store the database and
application files. A stable internet connection is also necessary if the system is
implemented as a web-based application.
The software requirements include a database management system such as MySQL
or PostgreSQL to store and manage event data. Programming languages such as
Java, Python, or PHP can be used to develop the application logic. For the user
interface, web technologies like HTML, CSS, and JavaScript can be used to design
interactive web pages.
Additionally, development tools such as Visual Studio Code or Eclipse can be used
for coding and debugging. A web server like Apache or Tomcat may also be required
to host the application.
The use of these hardware and software components ensures that the system runs
efficiently and supports multiple users simultaneously. It also enables easy
maintenance and scalability for future improvements.

Working Principle

The working principle of the Event Management System is based on the interaction between
users and the database through the application interface. The system allows event organizers
to create and manage events while attendees can browse and register for events.
When an organizer creates an event, the system stores event details such as event name,
date, time, and venue in the database. The system checks whether the selected venue is
available before confirming the event scheduling. This helps avoid conflicts between events.
Attendees can view available events and register for them through the system. Once an
attendee registers, their details are linked to the event in the database. This establishes a
relationship between the Attendees and Events entities.
The system also keeps track of venue capacity to ensure that the number of attendees does
not exceed the allowed limit. Notifications and updates can be sent to attendees regarding
event schedules.
The ER model ensures that all these operations are handled efficiently. The relationships
between entities help maintain data integrity and enable easy retrieval of information
such as attendee lists and
Software Implementation
The software implementation of the Event Management System involves converting the ER
model into a relational database and integrating it with an application interface. This step
ensures that the system works effectively in real-world scenarios.
First, the entities identified in the ER model are converted into tables in the database. For
example, the Events entity becomes an Events table, the Venues entity becomes a Venues
table, and the Attendees entity becomes an Attendees table. Each table includes primary
keys and relevant attributes.
Next, relationships between entities are implemented using foreign keys. For instance, the
Events table contains a Venue_ID that links it to the Venues table. Similarly, a separate
Registration table is created to manage the many-to-many relationship between Attendees and
Events.
The application is then developed using programming languages and frameworks. The frontend
provides forms for creating events, registering attendees, and viewing event details. The
backend processes user requests and communicates with the database.
Testing is conducted to ensure that all features work correctly. The system is then deployed on
a server so that users can access it.
This implementation ensures efficient event management and reliable data storage.

-- EVENT MANAGEMENT SYSTEM DATABASE IMPLEMENTATION

-- 1. Create Database
CREATE DATABASE
EventManagementSystem; USE
EventManagementSystem;

-- =====================================================
-- 2. Create Tables based on ER Model
-- Entities: Venues, Events, Attendees
-- Relationship: Registration
-- =====================================================

-- Venues Table
CREATE TABLE Venues (
Venue_ID INT AUTO_INCREMENT PRIMARY
KEY, Venue_Name VARCHAR(100) NOT
NULL, Location VARCHAR(100) NOT NULL,
Capacity INT NOT NULL
);

-- Events Table
CREATE TABLE Events (
Event_ID INT AUTO_INCREMENT PRIMARY KEY,
Event_Name VARCHAR(100) NOT NULL,
Event_Date DATE NOT NULL,
Event_Time TIME,
Venue_ID INT,
Description TEXT,
FOREIGN KEY (Venue_ID) REFERENCES Venues(Venue_ID)
);

-- Attendees Table
CREATE TABLE Attendees (
Attendee_ID INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
Email VARCHAR(100)
UNIQUE, Phone
VARCHAR(15),
Organization VARCHAR(100)
);

-- Registration Table (Many-to-Many

Relationship) CREATE TABLE Registration (
Registration_ID INT AUTO_INCREMENT PRIMARY
KEY, Event_ID INT,
Attendee_ID INT,
Registration_Date
DATE, Status
VARCHAR(50),
FOREIGN KEY (Event_ID) REFERENCES Events(Event_ID),
FOREIGN KEY (Attendee_ID) REFERENCES
Attendees(Attendee_ID)
);

-- =====================================================
-- 3. Insert Sample Data
-- =====================================================

-- Insert Venues
INSERT INTO Venues (Venue_Name, Location, Capacity) VALUES
('Convention Center', 'Hyderabad', 500),
('Auditorium Hall', 'Bangalore',
300), ('Seminar Room',
'Chennai', 100), ('Conference
Hall', 'Delhi', 200);

-- Insert Events
INSERT INTO Events (Event_Name, Event_Date, Event_Time, Venue_ID, Description)
VALUES ('Tech Conference', '2026-04-10', '10:00:00', 1, 'Annual technology
conference'),
('AI Workshop', '2026-04-15', '09:30:00', 2, 'Hands-on Artificial Intelligence workshop'),
('Startup Meetup', '2026-05-01', '11:00:00', 3, 'Networking event for startups'),
('Data Science Seminar', '2026-05-20', '02:00:00', 4, 'Seminar on Data Science trends');

-- Insert Attendees
INSERT INTO Attendees (Name, Email, Phone, Organization)
VALUES ('Rahul Kumar', 'rahul@[Link]', '9876543210', 'ABC
Company'), ('Sneha Reddy', 'sneha@[Link]', '9123456780',
'XYZ Solutions'), ('Arjun Patel', 'arjun@[Link]',
'9988776655', 'Tech Innovators'), ('Priya Sharma',
'priya@[Link]', '9871234560', 'Startup Hub');

-- Insert Registrations
INSERT INTO Registration (Event_ID, Attendee_ID, Registration_Date, Status)
VALUES (1, 1, '2026-03-20', 'Confirmed'),
(1, 2, '2026-03-21', 'Confirmed'),
(2, 3, '2026-03-22', 'Pending'),
(3, 4, '2026-03-23', 'Confirmed'),
(4, 1, '2026-03-23', 'Confirmed');
-- =====================================================
-- 4. Queries for Event Management System
-- =====================================================

-- View all venues

SELECT * FROM
Venues;

-- View all events

SELECT * FROM
Events;

-- View all attendees

SELECT * FROM
Attendees;

-- View all registrations

SELECT * FROM
Registration;

-- Display Events with Venue

Details SELECT
Events.Event_Name,
Events.Event_Date,
Events.Event_Time,
Venues.Venue_Name,
[Link]
FROM Events
JOIN Venues ON Events.Venue_ID = Venues.Venue_ID;

-- Display Attendees Registered for

Events SELECT
[Link],
[Link],
Events.Event_Name
FROM Registration
JOIN Attendees ON Registration.Attendee_ID =
Attendees.Attendee_ID JOIN Events ON Registration.Event_ID =
Events.Event_ID;

-- Count number of attendees per event

SELECT
Events.Event_Name,
COUNT(Registration.Attendee_ID) AS
Total_Attendees
FROM Events
LEFT JOIN Registration ON Events.Event_ID =
Registration.Event_ID GROUP BY Events.Event_Name;

-- Check venue capacity usage

SELECT
Venues.Venue_Name,
[Link],
COUNT(Registration.Attendee_ID) AS
Registered_Attendees FROM Venues
JOIN Events ON Venues.Venue_ID = Events.Venue_ID
LEFT JOIN Registration ON Events.Event_ID =
Registration.Event_ID GROUP BY Venues.Venue_Name;
-- =====================================================
-- 5. Update and Delete Operations
-- =====================================================

-- Update event details

UPDATE Events
SET Event_Time = '03:00:00'
WHERE Event_ID = 4;

-- Update attendee phone

number UPDATE Attendees
SET Phone = '9999999999'
WHERE Attendee_ID = 2;

-- Delete a registration
DELETE FROM
Registration WHERE
Registration_ID = 3;

-- =====================================================
-- 6. Advanced Queries
-- =====================================================

-- Find upcoming events

SELECT * FROM Events
WHERE Event_Date >= CURDATE();

-- Find events at a specific

location SELECT
Events.Event_Name,
[Link]
FROM Events
JOIN Venues ON Events.Venue_ID =
Venues.Venue_ID WHERE [Link] =
'Hyderabad';

-- Find attendees attending multiple

events SELECT
[Link],
COUNT(Registration.Event_ID) AS
Number_of_Events FROM Registration
JOIN Attendees ON Registration.Attendee_ID =
Attendees.Attendee_ID GROUP BY [Link]
HAVING COUNT(Registration.Event_ID) > 1;

-- =====================================================
-- END OF EVENT MANAGEMENT SYSTEM IMPLEMENTATION
-- ====================================================
 Results and Discussion

The implementation of the Event Management System using an ER model

provides several advantages in managing events effectively. The system
successfully organizes event data and maintains relationships between
events, venues, and attendees.
One of the major outcomes is improved data management. All event-related
information is stored in a structured format, making it easy to retrieve and
update. The system also prevents scheduling conflicts by ensuring that a
venue cannot host multiple events at the same time.
Another result is better participant management. Attendees can easily
register for events, and organizers can track the number of participants. This
helps in planning resources and managing venue capacity.
The ER model also improves database efficiency by reducing redundancy.
Since information is stored in separate tables with proper relationships,
duplicate data is minimized. This leads to better system performance.
Additionally, the system enhances user experience by providing quick access
to event information. Organizers can manage events easily, and attendees
can stay informed about upcoming events.
Overall, the results show that using an ER model is an effective approach for
designing and implementing an event management system.
Mapping POs and SDGs

Mapping Program Outcomes (POs) and Sustainable Development

Goals (SDGs) helps in understanding how the project contributes
to academic learning and global development objectives. This
project supports both technical and societal goals.
The development of the Event Management System enhances
students' knowledge in database design, software development,
and system architecture. It also improves problem-solving skills
and understanding of real-world applications.
From a sustainability perspective, the system promotes efficient
resource management. By organizing events digitally, the system
reduces paperwork and improves communication among
participants. This contributes to environmentally friendly
practices.
The project also encourages the use of technology to support
community engagement and event coordination. By simplifying
event management, organizations can conduct events more
effectively and reach a larger audience.
Therefore, the project aligns with both academic outcomes and
global sustainability initiatives.

6.1 Program Outcomes (POs) Mapping

The Event Management System project contributes to several
program outcomes in computer science and engineering education.
It helps students apply theoretical knowledge to practical
problems.
Students learn how to design and implement databases using ER
models, which strengthens their understanding of data structures
and database management systems. The project also improves
programming and system design skills.
Another important outcome is teamwork and project management.
Developing such systems often requires collaboration among team
members, which enhances communication and coordination
abilities.
The project also promotes analytical thinking and problem-solving.
Students must identify system requirements, design efficient
solutions, and test the system thoroughly.
Furthermore, it improves technical documentation skills, as
students need to prepare reports and explain system architecture
and functionality.
Overall, the project helps students achieve important learning
outcomes that are essential for their professional development in
the field of software engineering.

6.2 Sustainable Development Goals (SDGs) Mapping

The Event Management System supports several Sustainable
Development Goals by promoting digital transformation and
efficient resource utilization. Technology plays a key role in
achieving sustainable growth and development.
One relevant SDG is Quality Education. The project enhances
learning by allowing students to apply their knowledge in real-
world scenarios. It also encourages innovation and research in
technology.
Another SDG supported by this project is Industry, Innovation, and
Infrastructure. By developing a digital platform for event
management, the project contributes to technological
advancement and improved infrastructure.
The system also supports Responsible Consumption and
Production by reducing the need for paper-based event
management processes. Digital records help in minimizing waste
and improving efficiency.
Additionally, the system encourages collaboration and
communication among people participating in events, which helps
build stronger communities.
Therefore, the project aligns well with global sustainability
goals and demonstrates how technology can be
used to solve real-world problems.
Conclusion

The Event Management System designed using an ER model provides an efficient way to
manage events, venues, and attendees. The ER model helps in visualizing the relationships
between different entities and ensures proper database design.
Through this project, it becomes clear that a well-structured database is essential for
managing complex systems. The relationships between Events, Venues, and Attendees allow
the system to function smoothly and maintain accurate records.
The implementation of the system demonstrates how database concepts can be applied to
real-world applications. It also highlights the importance of planning and designing before
developing software.
The system improves event organization by reducing scheduling conflicts, managing
participant data, and ensuring efficient resource utilization. It also provides a user-friendly
interface for both organizers and attendees.
In the future, the system can be enhanced by adding features such as online payments,
automated notifications, and mobile application support.
Overall, the project successfully demonstrates the design and implementation of an event
management system using ER modeling techniques.
 Bibliography

Bibliography
1. Database System Concepts – Abraham Silberschatz, Henry F. Korth, S.
Sudarshan.
This book provides fundamental concepts of database systems, including
ER modeling, relational databases, and database design techniques used
in developing systems such as event management platforms.
2. Fundamentals of Database Systems – Ramez Elmasri and
Shamkant B. Navathe. The book explains database design
methodologies, entity-relationship models, normalization, and
implementation of relational database systems.
3. Oracle Corporation – MySQL Documentation.
Official documentation used for understanding database creation,
table relationships, and implementation of ER models in real-world
applications.
4. W3Schools.
Online learning resource used for studying SQL queries, database
concepts, and practical examples related to database management
systems.
5. IEEE Digital Library.
Research papers and articles related to event management systems
and database design were referred to for understanding system
architecture and implementation techniques.
6. Google Scholar.
Used to explore research papers and studies on ER modeling and
event management system development.