Question 1 Python Programming (100 points) Create Hotel Booking application. This application allows the user to view the available hotels and book a room in this hotel. The application has the following database schema: Hotels (HotelID, Name, Picture, StarRating, CityName) Rooms (RoomNumber, HotelID*, RoomType, MaxGuest, Rate) Reservations (ResNb, GuestName,GuestEmail, RoomNumber*, StartDate, EndDate) The application is connected to a web service that returns the below JSON String: { "hotels": [ { "hotel_id": "5568", "name": "Radisson Blu Hotel", "street": "Evliya Celebi Mah. Refik Saydam Cad. No 19 Tepebasi Taksim", "city": "Istanbul", "country": "Turkey", "latitude": 52.51624, "longitude": 13.380437, "desc": "Located in Pera district, the centre of culture, art, fine dining and nightlife, Radisson Blu Hotel Istanbul Pera has a restaurant with stunning views of the Golden Horn and old city Istanbul", "facilities": [ "Beauty Center", "Business Center", "Caf/ Bistro", "Sauna" ], "email": "adlon@adlon.com", "phone": "030-123123", "review-score": 9.2, "Star-rating": 3, "hotel-pictures": [ "https://rcf. bstatic.com/images/hotel/max1024x768/688/68813338 .jpg", "https://qcf. bstatic.com/images/hotel/max1024x768/213/21306836 .jpg", "https://rcf. bstatic.com/images/hotel/max1024x768/213/21307269 .jpg" ], "room_types": [ { "room-type": "Single Room", "room-size": "15", "room-price": 40,"available-rooms": 0 }, { "room-type": "Double Room", "room-size": "27", "room-price": 55,"available-rooms": 3 Page 2 of }, { "room-type": "Triple Room", "room-size": "35", "room-price": 85,"available-rooms": 8 }, { "room-type": "Superior Suite", "room-size": "40", "room-price": 150,"available-rooms": 4 } ] }, { "hotel_id": "5168", "name": "Pera Center Hotel & Spa", "street": "Katip Mustafa elebi Mahallesi, Billurcu Sokak, No:14", "city": "Istanbul", "country": "Turkey", "latitude": 41.034277, "longitude": 28.983639, "desc": "Only 200 m from the lively Istiklal Street, Pera Center Hotel is located 350 m from Taksim Square, the modern heart of Istanbul.", "facilities": [ "Non-smoking rooms", "Airport shuttle", "Fitness centre", "Spa and wellness centre" ], "email": "pera@pera.com", "phone": "030-123123", "review-score": 8.2, "Star-rating": 4, "hotel-pictures": [ "http://peracenterhotel.com/wpcontent/ uploads/2016/11/419B3656.jpg", "http://peracenterhotel.com/wpcontent/ uploads/2016/12/standart-3-kisilik-oda- 4.jpg", "http://peracenterhotel.com/wpcontent/ uploads/2016/12/sauna.jpg" ], "room_types": [ { "room-type": "Single Room", "room-size": "15", "room-price": 35,"available-rooms": 2 }, { "room-type": "Double Room", "room-size": "27", "room-price": 58,"available-rooms": 2 }, { "room-type": "Twin Room", "room-size": "27", "room-price": 86,"available-rooms": 5 }, { "room-type": "Triple Room", "room-size": "35", "room-price": 105,"available-rooms": 0 }, { "room-type": "Superior Suite", "room-size": "40", "room-price": 155,"available-rooms": 7 } ] } ] } Page 3 of Write a python application that connect to the server and download the JSON String then ask the user to select the city from a list of hotels (Hotel Name, City, Star Rating). When the user select one of the available hotels, the list of available rooms will appear