Hotel Management Database

A group project for my database systems class, modeled loosely on how a hotel chain might manage reservations — guests, rooms, rates, and bookings.

I worked on the PL/SQL side: stored procedures for searching room availability, booking a room, modifying an existing reservation, and pulling basic occupancy and revenue reports.

It was my first real exposure to writing and testing procedural SQL against a schema built by a team rather than just myself, which came with its own lessons about naming conventions and not stepping on each other's tables.