# PALMORA: Full-Stack Hotel Reservation System Project
> A comprehensive software engineering presentation for PALMORA, a hotel management system featuring real-time booking, mobile app UI, and 4-layer architecture.

Tags: hotel-reservation-system, software-engineering, full-stack-development, ui-ux-design, system-architecture, booking-algorithm, project-management
## PALMORA: Hotel Reservation System
* Final project presentation for CMSE322 Software Engineering.
* Aim: Digitize bookings to replace manual phone and paper logs.

## Scope & Objectives
* Guest Booking Portal: Real-time search and filtering.
* Receptionist Dashboard: Manage check-ins and room status.
* Admin Control Panel: Analytics and user role management.
* Role-Based Access: Guest, Receptionist, and Administrator accounts.

## Development Toolkit
* UI/UX: Figma and Poppins Typography.
* Database: MySQL relational management.
* Documentation & Modeling: MS Project, GitHub, and UML tools.

## System Architecture
* **Layer 1 (Presentation):** Mobile app UI and Web dashboard.
* **Layer 2 (Business Logic):** Booking engine and payment handler (Stripe API).
* **Layer 3 (Data Access):** ORM/JDBC for CRUD operations.
* **Layer 4 (Database):** MySQL tables for users, rooms, and payments.

## Quality Assurance & Testing
* Total Tests: 24 (22 Passed, 1 Failed, 1 Pending).
* Functional testing included valid credential login and available room booking.

## Booking Workflow Algorithm
1.  **Search:** Parse date/room parameters.
2.  **Availability:** SQL SELECT to check overlaps.
3.  **Reservation:** Apply row-level locking constraint.
4.  **Payment:** Stripe API integration with rollback support.
5.  **Confirmation:** UUID Booking ID generation.
---
This presentation was created with [Bobr AI](https://bobr.ai) — an AI presentation generator.