Design and Implementation of a Database System for Event Management Customizer (EMC): A Case-Based Approach

Database systems are central in the organization and management of complex data with a view to accuracy, accessibility, and scalability. This paper describes the design and implementation of a customized database system for Event Management Customizer, a Subang Jaya-based startup in Malaysia specializing in adventure holidays and team-building events. The main goal was to manage client bookings, accommodate and facility management, and enhance operational efficiency. It also includes the design of a database system, using methodologies such as ER and physical modelling, ending with an implementation based on MySQL. Based on this, eight interconnected entities have been identified: Client, Representative, Accommodation, Booking, Outdoor Facilities, Additional Facilities, Payment, and Staff. The defined key attributes, composite attributes, and derived attributes will present the structure of the proposed system. Features such as facility hire charges, accommodation details, and staff assignments provide comprehensive data management. It further enhanced the system to real-world, scenario-based SQL queries identifying high-transaction clients, calculating additional charges, and even evaluation of staff performances. Further enhancements could also be made upon the challenges they faced, for instance, COVID-19 pandemic-addition of vaccination statuses, quarantine records, and room disinfection schedules. This database design has demonstrated the flexibility of database systems in solving organizational challenges; it also has proved that the database systems are vital in maintaining operational integrity, decision-making, and adapting to unforeseen global disruptions.