Task:
Finally, using the work you have done in Parts 1 and 2 above, you need to present the work you have done and provide answers to the following questions in a short video. You should show your face at least at the beginning and end of the presentation and show the content of the ACCESS and EXCEL files where appropriate. Below is a summary of the components of the video presentation. To ensure your lecturer can open the video file, please use the MP4 format.
1.Short introduction to the presentation.
2.Changes you made in the Customer table.
3.The design of the Employees table (attributes, field type, primary key).
4.Explain the cardinalities among the tables in the Entity-relationship diagram
5.What is the most popular length of stay? How many bookings have been made for that length of stay?
6.Typically how many rooms are there in each hotel? Is there huge difference between hotels?
7.Which hotel has the highest number of non-smoking and no pet rooms? How many? Which hotel has the lowest number of non-smoking and no pet rooms? How many?
8.What are the top THREE occupation of the hotel’s customers?
9.Which hotel has the highest capacity? What is the capacity? Which hotel has the lowest capacity? What is the capacity?
10.Which hotels attract senior customers who age 55 years old or above?
11.How many records and attributes in Access were exported to Excel for analysis?
12.Explain the formula used to combine the full name of Gary Edwards.
13.Explain the formula used to calculate the age of Gary Edwards.
14.Explain the formula used to determine the generation category of Gary Edwards?
15.How much did Gary Edwards pay for his visit? Explain the formula used to calculate the income from Gary Edwards’ stay.
16.Do customers in general prefer the no pet and no smoking rooms? Are the results consistent across different generations? Hint: compare the booking percentage
17.Did the hotel with the highest capacity bring in the highest income? If not, which hotel brought in the highest income?
18.Did the hotel that had the highest income out-perform the second best performed hotel in all quarters? If not, in which quarter did the second best hotel perform better? 19.Conclusion: based on the analysis, provide two suggestions to Dr. Brown regarding a future marketing campaign.
Comments