Added on:
Mar 24, 2025
User Prompt
Hotel Booking System
Description: Manages hotel guests, rooms, and bookings.
Classes & Relationships:
Guest (guest_id, name, contact)
Room (room_id, type, price, availability)
Booking (booking_id, guest_id, room_id, check_in, check_out)
Payment (payment_id, booking_id, amount, status)
Relationships:
A Guest makes multiple Bookings.
A Booking is for a Room.
A Booking requires a Payment.