Presentation2

WEB-BASED HOTEL ROOM RESERVATION AND MANAGEMENT SYSTEM A CAPSTONE PROJECT Bachelor of Science in Information Technology YLLANA BAY VIEW COLLEGE Presented by:JOHNDEE JR. D. MALALIS SIELO M. DAGUPAN NORWIN T. BAWAN.

Contents Project Introduction and Objectives System Architecture and Logical Flow Functional and Data Modeling System Implementation and Features.

01 Project Introduction and Objectives.

Presentation Title & Overview Modernization The Web-Based Hotel Room Reservation and Management System is designed to transition hospitality businesses from paper-based or fragmented digital methods to a unified, cloud- compatible platform. Accessibility The system serves as a bridge between hoteliers and global travelers, providing a user-friendly interface that allows for 24/7 booking capabilities without geographical constraints. Efficiency By integrating front-desk operations with back-end management, the overview emphasizes a significant reduction in administrative overhead and a streamlined guest experience..

Problem Statement Manual inefficiency Traditional paper-based booking systems lead to slow processing times and a high frequency of human errors in record-keeping. Fragmented communication Lack of real-time synchronization between front-desk operations and online availability results in frequent overbooking and customer dissatisfaction. Data management challenges Difficulty in retrieving historical guest data and generating accurate financial reports hampers strategic decision-making for management..

02 System Architecture and Logical Flow.

BPO (Business Process Outsourcing) Diagram BOOK Payment Integration The system connects to external payment gateways to facilitate secure online transactions, ensuring real- time payment verification and automated receipt generation. Communication Services Third-party SMS and email APIs are integrated to provide automated booking confirmations, check-in reminders, and promotional offers to guests. Cloud Hosting Scalable cloud infrastructure is utilized to ensure high availability and data redundancy, allowing the hotel management dashboard to remain accessible across various devices..

Context Diagram External Entity Interaction 01 Define the data flow boundaries between the system and external actors like guests, hotel staff, and payment gateways. Central Process Definition 02 Represent the core reservation system as a single process to illustrate its primary ftnctions within the environment. Information Exchange Interface 03 Specify the input and output requirements for user authentication, room availability queries, and booking confirmations..

24 03 Functional and Data Modeling.

Workflow Analysis User booking process Customers search for available rooms, select dates, and complete the payment through a secure gateway. Administrative management cycle Staff monitor room status, verify check-ins/check-outs, and update inventory in real-time. Automated notification system The platform triggers instant email or SMS confirmations upon successful reservation or cancellation. Select dates OCTOBER 2022 wed Thu Mon 3 24 Tue 4 25 12 19 13 20 8.

Entity Relationship Diagram (ERD) 01 Data structures Define the core entities including Guests, Rooms, Reservations, and Payments to establish a logical database framework. Cardinality constraints 02 Relationship mapping Illustrate the one-to-many and many-to-many associations between users and booking records to ensure data integrity. 03 Specify the numerical constraints of entity relationships to optimize query performance and prevent data redundancy..

[image] Room Info Room Type Customer Info Reservation Admin Billing Comments Company Info Reports Database Backup Customer.

Entity Relationship Diagram (ERD) 01 Data structures Define the core entities including Guests, Rooms, Reservations, and Payments to establish a logical database framework. Cardinality constraints 02 Relationship mapping Illustrate the one-to-many and many-to-many associations between users and booking records to ensure data integrity. 03 Specify the numerical constraints of entity relationships to optimize query performance and prevent data redundancy..

so.uue,0d pue uoyeauoulöldull tuo»Rs.

System Functional Modules Reservation Portal A user-friendly front-end interface that allows guests to search for available rooms, view amenities, and complete bookings through a streamlined checkout process. Admin Dashboard A centralized management hub for hotel staff to oversee room inventory, update pricing dynamically, and generate comprehensive sales reports. Review System An integrated feedback module where guests can rate their stay and provide comments, helping the hotel maintain service quality and build social proof. User Management A dual-interface system featuring a personalized dashboard for guests to track history and an administrative panel for managing employee permissions..

Technical Stack & Environment Frontend Framework React.js for building a responsive and dynamic user interface. Backend Architecture Node.js with Express for scalable server-side logic and RESTful API management. Database Management MySQL or PostgreSQL for robust relational data storage and transactional integrity..

noR »luetll.