Design a Hotel Booking System

Design a hotel booking system that allows users to search for hotels, make reservations, and manage bookings. Focus on data modeling and SQL queries for handling room availability, pricing, and reservation management.