Design and Implementation of a Travel Booking Platform Database

Ing. Jabed Mahmud, BBA

Diplomová práce

Abstract:

This thesis describes the complete design, implementation, and testing of a normalized relational database system for a travel booking business, built using MySQL 8.0 inside an XAMPP local development environment. A real-life issue I had observed and researched formed the basis of the project: most small and medium-sized travel agencies continue to store their data in spreadsheets or poorly conceived databases, which suffer from redundancy, inconsistency, and lack of automated business rule enforcement. I wanted to design a purpose-built system, grounded in first principles, that would address all three of those issues. I structured the development using the Database Development Life Cycle (DBLC) and the Structured System Analysis and Design Method (SSADM). The database contains 10 tables organised into three layers: Master Data, Product Catalogue, and Transactional, normalised throughout to Third Normal Form (3NF). There are explicit ON DELETE and ON UPDATE phenomena with 12 foreign key relationships. I have recorded the normalisation process step by step, starting with an Unnormalised flat table and progressing to 1NF, 2NF, and 3NF using real sample data from the database. The automation of the most important business rules is implemented through five triggers: overbooking, payment-driven booking confir-mation, refund-driven cancellation, and audit trail logging. It contains 15 SQL queries that provide both operational and analytical information for 10 tables.

Keywords

Database design, Database triggers, Query optimization.

Jazyk práce: angličtina

Datum vytvoření / odevzdání či podání práce: 1. 4. 2026

Obhajoba závěrečné práce

• Vedoucí: Ing. Jakub Konopásek, Ph.D.
• Oponent: Tereza Martínková Bártlová, externi

Česká zemědělská univerzita v Praze

Provozně ekonomická fakulta

Magisterský studijní program:
Informatics