shaky foundation.
1. If you are going to do this, at least have a hotel table so you can handle multiple hotels.
2. Bookings and Reservations are the same thing. Maybe you mean Booking and Occupancy because a guest can book a room but cancel. I would use the same table. Just include a Check in date/time.
3. Your FK names are inconsistent
4. Room rates are more complicated than your schema allows. Not only are they dependent on room type but they are dependent on week day and season. So, at a minimum the tariff table needs a start and end date.