University Database Design Project: Booking.com Database Structure

This document presents a comprehensive database design for Booking.com, a popular online travel platform. The assignment begins with an overview of the website's functionalities, including account creation, flight and accommodation bookings, car rentals, and airport taxi services. Based on these functionalities, the student identifies seven key tables: Customer, AccommodationBooking, FlightBooking, CarBooking, AirportTaxi, Trip, and Payment. Each table's attributes, including primary and foreign keys, are meticulously defined. The design decisions emphasize the use of 3NF normalization to ensure data integrity and efficiency. The report also includes an entity-relationship diagram (ERD) created using MS Visio. Furthermore, the assignment addresses potential improvements to the database, such as the addition of a payment table and more detailed city and travel spot tables. The student has created a well-structured and detailed database design for the Booking.com platform.