Design and Implementation of a Relational Database System for Efficient Facility and Booking Management

The paper describes the conception and development of a relational database system for facility bookings. The design of the database was based on an Entity-Relationship Diagram (ERD) to outline entities, relationships, and attributes, thus ensuring an optimally scalable system. The practical realization consisted of establishing multiple interrelated tables to hold data about facilities, sites, bookings, clients, and employees. SQL queries were used for constructing the schema, inserting data, and producing business intelligence-related insight reports. The pandemic scenario outlines how the database system might have changed with the introduction of other unexpected global challenges. Findings illustrate how the developed system organizes data better, enhances transaction processing, and provides management analytics for decision-making at facilities. This study demonstrates how important relational databases are for facilitating operations while ensuring data integrity during any business or institutional application.