HRGSMS

Overview

A centralized platform designed to streamline operations for a multi-branch hotel chain, managing real-time reservations, guest services, and automated billing across three locations. Developed as part of a 5-member team for a database systems practicum.

Key Highlights

• Multi-branch management architecture for Weligama, Midigama, and Ahangama locations
• Real-time reservation module with availability tracking to prevent double-bookings
• Automated billing and payment system supporting multiple methods including slip uploads
• Implementation of SQL transactions, stored procedures, and triggers to ensure high data consistency
• Role-based access control (RBAC) ensuring secure data isolation between different staff levels and branches

Tech Stack