← All work

Hotel Booking Management System

04 / 2023

A transactional booking platform built with a four-person team, where the interesting problem was preventing double bookings.

01

Client interface

02

Booking logic (C#)

03

Transaction guard

04

SQL Server

Concurrent reservations against shared inventory, resolved in the transaction.
Type
Team project, UCT
My role
Schema & booking logic
Stack
C#/.NETMicrosoft SQL Server

A team project at UCT: a transactional booking platform in C#/.NET backed by Microsoft SQL Server, delivered by four of us.

I owned the normalised relational schema and the booking business logic in C#. Reservations against shared inventory are where booking systems actually break, so that is where the design effort went.

I also wrote the test cases that caught the double-booking edge cases before the demo, which is the reason the demo went cleanly.

Next project

RoboChess Gymnasium