1) What is the average length of stay per room type?
2) What is the average number of visitor per room type?
3) What is the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time?
4) What is the strongest customer base? Analyze the data in the database and in the application exercise.
To complete this assignment, you will need to do data calculations. Remember to follow good database practice here by not saving your calculations as part of the data table itself (they should appear only in your queries).
Create queries and reports that will provide information to help management at the Queen's Inn to be more competitive and profitable. If you look at the original database you downloaded, you will see that it provides suggestions for the three reports that should be created for The Queen's Inn. These empty templates will give you an indication of what queries and reports you must create for this assignment.
Attachment:- Assignment.rar