Tech Stack
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 handling 1,000+ bookings annually, eliminating data redundancy by 80%.
Created an efficient 'Room Availability' algorithm that automatically filters rooms based on check-in/out dates, reducing booking errors by 95%.
Key Achievements
- Streamlined booking process for 50-room hotel with 1,000+ annual bookings.
- Reduced data redundancy by 80% through normalized database design.
- Decreased booking errors by 95% with automated availability checking.