Hotel Management System
A web application to streamline guest bookings and room management, featuring a custom availability algorithm.
Jan 2023 – Jun 2023 · Open source · PHP, MySQL, Database Design
Overview
Built a comprehensive web application to streamline guest bookings and room management for a 50-room hotel.
Designed a normalized relational database for rooms, guests, reservations, and payment records.
Created a room-availability algorithm that filters inventory by check-in and check-out dates to prevent overlapping bookings.
Features
- Streamlined booking process for 50-room hotel with 1,000+ annual bookings.
- Reduced duplicated booking data through a normalized relational schema.
- Prevented overlapping reservations with automated availability checks.