A local hotel needs a system that keeps track of its bookings (future, current and archived), rooms and guests. A room can be of a particular type and a particular price band. Room prices vary from a room to a room (depending on its type, lists of facilities, etc.). A room booking can include more than one room and more than one customer. A Customer can make one or many Bookings. Each customer is identified by a unique customer id. The hotel stores each customer first name, last name, the country, city, street where customer lives. Also, the hotel stores a one or more mobile number for each customer if exist. Each booking is identified by a unique id. A hotel keeps track of the customer's the start, end date of booking and total payment due amount. A payment number identify a particular payment for a specific booking. The date and amount are recorders for each payment. A Booking can be for one or many Guests - the Guest is not necessarily the person who makes the Booking. Page | 3 A Room is identified by unique id. The database must store the floor of each room. A Room can be on one or many Bookings. A Room may have many different Room Facilities.

B. Develop the database of the practical exercises using Microsoft SQL.