In this exercise, you will use database to analyze the reservation transactions for a hotel and use that information to fine-tune the hotel’s business strategy and marketing activities. this exercise encourages you to develop queries and reports in a database software to you make better use of transaction data to understand your business. the attached file hotel contains information about the president’s inn hotel in cape may, nj. at the inn, 10 rooms overlook side streets, 10 rooms have bay windows with limited views of the ocean, and the remaining 10 rooms in the front of the hotel face the ocean. room rates are based on room choice, length of stay, and number of guests per room. room rates are the same for one to four guests. fifth and sixth guests must pay an additional $20 per person per day. guests staying for seven days or more receive a 10 percent discount on their daily room rates. use the database to develop reports on average length of stay per room type, average visitors per room type, base revenue per room (i. e., length of visit multiplied by the daily rate) during a specified period of time, and strongest customer base. you may use the query wizard and report wizard capabilities of access. from analyzing these data, you should be able to find ways of generating more revenue. write a brief report about the inn’s current business situation and suggest future strategies in the word document. (12 points) in this exercise, you will use database to analyze the reservation transactions for a hotel and use that information to fine-tune the hotel’s business strategy and marketing activities. this exercise encourages you to develop queries and reports in a database software to you make better use of transaction data to understand your business. the attached file hotel contains information about the president’s inn hotel in cape may, nj. at the inn, 10 rooms overlook side streets, 10 rooms have bay windows with limited views of the ocean, and the remaining 10 rooms in the front of the hotel face the ocean. room rates are based on room choice, length of stay, and number of guests per room.