---

CREATE TABLE Hotel_Rooms (
    Room_Number INT PRIMARY KEY,
    Room_Type VARCHAR(50),
    Is_Free BOOLEAN
);

CREATE TABLE Bookings (
    Booking_ID INT PRIMARY KEY,
    Room_Number INT,
    Guest_Name VARCHAR(100),
    Paid_Amount DECIMAL(10, 2)
);