Efficient management of event registration and ticketing is crucial for the success of academic, corporate, and

social events. Traditional manual methods, including paper-based logs and unintegrated spreadsheets, are prone

to errors, duplicate entries, and operational delays, especially during high-volume registration periods. This study

featuring real-time input normalization and an interactive data visualization backend powered by ⁠matplotlib⁠.

Functional testing confirmed that all database joins, user-role authentications, and reporting modules operate

with zero record degradation. EventEase demonstrates how desktop applications can be built to optimize

operational capacity, remove data redundancy, and secure transactional integrity within institutional

environments.

Automation

Academic institutes and professional groups frequently organize events ranging from scientific seminars and

sports tournaments to student assemblies. Managing these functions requires stable coordination across logistics,

performance desktop application built in Python that replaces outdated, paper-based workflows with a unified

database structure and a modern graphical interface. Leveraging Python's development ecosystems alongside an

optimized SQLite relational engine allows the system to run locally with minimal hardware requirements while

maintaining transactional data safety. By implementing specialized security measures like SHA-256 password

hashing and Write-Ahead Logging, EventEase bridges the gap between accessible desktop software design and

enterprise-level data reliability.

This study aims to develop an Event Registration and Ticketing System that can manage, organize, and track

records efficiently through a GUI-based application. Manual ticketing and guest tracking processes often cause

slow entry lines, human counting mistakes, and issues with misplaced registration paper sheets. By building a

configurations?

How can the system reduce administrative errors, such as duplicate registration tokens or accidental log loss, by

providing automated database tools and immediate backup controls?

How can a GUI dashboard layout improve user interaction, navigation speed, and overall usability for event desk

staff?

The primary objective of this research is to design, develop, and deploy EventEase, a modern desktop application

that automates event registration and ticket tracking through an integrated database system.

The specific technical objectives include:

● Developing an asymmetric login gateway that securely authenticates users and directs them to the

calculate ticket costs, and generate digital receipts.

● Integrating a data visualization component within the admin dashboard to generate live metric

summaries and 7-day registration charts.

● Ensuring system data safety by implementing a secure, isolated database backup utility within the

application.

The development of this GUI-Based Event Registration and Ticketing System provides valuable practical

benefits to various groups involved in event organization and administrative management. Shifting from a

manual guest list to an automated desktop application reduces traditional bottlenecks and improves data security.

The specific individuals and groups who will benefit from this study include:

The specific individuals and groups who will benefit from this study include:

automated backup tools protect them from losing data and save time during heavy check-in hours.

experience at the venue.

Object-Oriented Programming (OOP) and Python database interfaces. The design provides a practical example

of combining data collection forms with secure back-end table relationships.

● Includes core modules: Dashboard, Add Record, View Records, Manage Events, and Settings.

● Functionalities include: Add Record, View Record, Update Information, Cancel Ticket, Clear Inputs.

● GUI is simple and direct but not responsive to advanced themes or multiple devices.

● Cannot associate tickets directly under specific assigned events.

● Does not include online payment or multi-user network support.

● Deployment Architecture: Operating as a local desktop program, the system requires the Python runtime

environment and dependencies (⁠customtkinter⁠, ⁠tkcalendar⁠, ⁠pillow⁠, ⁠matplotlib⁠) to be installed on the host

machine.

● Networking: The application uses a local SQLite database file, meaning it does not sync across an online

cloud network or support multi-device setups without shared local network storage.

● Payment Gateways: Financial checkout functions use a simulated local point-of-sale cash window that

calculates change, rather than connecting directly to third-party digital payment APIs or credit card

GUI-based event registration systems provide a visual and interactive platform for attendees and administrators,

enhancing usability, efficiency, and data accuracy.

up registration while ensuring participant validation.

ticket reservation and attendee management.

navigation and accessibility, reducing reliance on third-party tools.

accelerate entry.

prevent unauthorized access, scalping, and fraudulent ticket sales.

time:

Delete) operations for attendee and event data (SQLite Consortium, 2024).

Automated systems minimize errors, prevent duplicate registrations, and centralize record storage for efficient

event management.

OOP principles enable modular, reusable, and maintainable code in software applications:

and data integrity in event management.

inefficient registration workflows. Determine the need for Python for programming and SQLite for local

database persistence.

clears input fields, and refreshes tables to reflect the latest state of records.

This study utilized different tools and technologies in developing the proposed GUI-based (System Title). The

flexibility, and effectiveness in creating desktop applications. Python also provides libraries and frameworks that

support graphical user interface (GUI) development and database integration, making it suitable for building an

efficient and user-friendly system.

The data is synchronized instantly into a clean tabular data view component (ttk.Treeview).

dedicated entirely to database auditing. It functions as a complete data grid that displays all currently active ticket

logs stored inside the database schema. This layout isolates large datasets from modification fields, preventing

function handles macroscopic event organization. It allows administrative personnel to dynamically create new

events by mapping dedicated Event Keys, Titles, and target Venue Locations directly into a secondary, isolated

relational table within the database. It also includes an administrative purge command to permanently drop event

records when cancellations occur.

event attendance efficiently.

selected row without affecting other entries.

Cancels an attendee’s ticket by changing the status to “CANCELLED”, preserving the historical data while

format, allowing administrators to efficiently monitor event schedules, venue assignments, participant capacity

their personal account information, security credentials, and application preferences. The interface is divided

user experience by providing convenient account management features while promoting system security through

credential maintenance and personalized interface configurations.

a specific record and permanently remove it from the system, usually accompanied by a confirmation prompt to

prevent accidental deletion.

and financial information into a single interface, the dashboard supports efficient decision-making, performance

monitoring, and overall event administration.

This section presents the results of the functional testing conducted to evaluate the reliability, accuracy, and

including attendee registration, ticket management, event scheduling, attendance tracking, report generation,

user management, and database operations. The testing process verified that all functions performed according

to their intended specifications and produced the expected outputs without critical errors.

operations, prevented duplicate ticket registrations, validated user inputs, generated accurate reports, and

Overall, the functional testing confirmed that EventEase is a stable, reliable, and user-friendly event registration

and ticketing system capable of supporting administrative operations efficiently while maintaining accurate and

secure data management.

The system demonstrates how Python programming, GUI development, and relational databases can be

corporate, and social events.

Based on the findings and limitations, the following recommendations are proposed:

unauthorized access.

Software Docs. https://docs.python.org/3/library/sqlite3.html

15. SQLite Consortium. (2024). About SQLite. SQLite Documentation. https://www.sqlite.org/about.html

National High School (MNHS), a public school in Antipolo City, Rizal. Currently, he is focused on studying

programming and Computer-Aided Design (CAD), aiming to deepen his technical knowledge to grow both

personally and professionally. Ultimately, he aspires to build a successful career as a computer engineer and

eventually pursue a second degree in Electronics Engineering, followed by a third degree in Culinary Arts.

continually expand his skills in both software development and system architecture. Upon graduation, he aspires

to build a successful and meaningful career within the engineering field.

from Silangan National High School (SNHS) where he’s group was awarded Best in Innovation, is currently

pursuing a Bachelor of Science in Computer Engineering (BSCpE) at the Eulogio "Amang" Rodriguez Institute

of Science and Technology (EARIST) in Manila, Philippines. Dedicated to academic leadership and institutional

hardware integration, programming, computer-aided design, and automated systems architecture. To support

these pursuits, he leverages technical competencies in Python and C++ across environments including Dev C++

and PyCharm, alongside prior experience utilizing SolidWorks, Tinkercad, and embedded Arduino IDE to

design his award-winning automated irrigation prototype. Upon completion of his degree, he intends to transition

into the engineering industry with the long-term goal of contributing successfully to technological innovation

and professional advancement within the computer engineering field.

Notre Dame of Greater Manila and attended Caloocan High School. He is currently focused on learning about

- Asia Institute of Trade and Technology under the Accountancy, Business, and Management (ABM) strand.

Transitioning his organizational and business-oriented skills into the tech field, As a dedicated Volunteer Student

laboratories. Through this role, he performs basic PC troubleshooting and continuously hones his practical,

Teachers College (NTC), a private school on Mendiola Street, Manila. Currently, he is focused on expanding

his knowledge and skills in various areas of technology, particularly programming and Computer-Aided Design

(CAD). Through his studies in programming, he is learning to design, develop, and troubleshoot software

applications using different languages. Additionally, he is gaining experience in CAD, enabling him to create

the technical drawings, models, and engineering designs essential for modern technology projects.

based education. Passionate about teaching and innovation, she is dedicated to guiding Computer Engineering

students in becoming industry-ready, competent, and highly skilled individuals equipped for the evolving

demands of the technology industry.