← All projects

PC 318 Database Management Systems, Group 5 · 2026

Kubo Beach Resort

Reservation management for a beach resort's huts.

The problem

The resort tracked guests, kubo bookings, payments, and extra charges by hand. Double bookings and missing charges were easy to make and hard to find.

What I did

  • Planned the modules and split the work across a five-person team.
  • Kept the team on a pull request flow with CI on every push.
  • Owned the end-to-end testing of the staff and admin flows against the API.

The hard part

Keeping data rules in the database itself. Reservations, reserved kubos, and payments are handled by SQL functions with audit logs, so the order of deletes and updates matters.

Result

A working PERN app with JWT auth, admin and staff roles, audit logging, and light and dark themes.

Next projectSenior Citizen Verification →