Hotel Booking Data Platform
A normalized PostgreSQL backend and Flask API for hotel search, booking, and availability — built with a four-person team for our Database Systems course.
PostgreSQL
Flask
SQL
REST API
Python
Overview
For our Database Systems course project (Jan–Mar 2026), our four-person team designed and built a data platform for hotel bookings from the schema up. I focused on the database design and the Flask API layer that sits on top of it, making sure the data stayed consistent as multiple routes read and wrote to the same tables.
What I did
- Designed normalized PostgreSQL schemas for hotels, rooms, guests, and bookings to eliminate redundant data and keep updates consistent.
- Developed Flask routes for authentication, search, booking, availability, and status-management APIs.
- Wrote and validated reusable SQL queries and constraints (foreign keys, checks, uniqueness) to enforce data integrity across the schema.
- Collaborated with a four-person team through iterative testing and code review to catch edge cases in booking and availability logic.
Tech stack
PostgreSQL
Flask
SQL
REST-style APIs
Python