Get ACCT5011 Accounting System In Digital Age Assignment Question and Answer
Looking for help with ACCT5011 Accounting System In Digital Age assessment answer? Come to us at Assignmenthelpaus for some customized accounting assignment help and essay writing help that gets you the topmost scores in class.
Assignment Details:
- Referencing Styles: Not Selected
- Course Code: ACCT5011
- Course Title: accounting system in digital age
- Words: 1500
- University: Curtin University
- Country: AU
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.
- Short introduction to the presentation.
- Changes you made in the Customer table.
- The design of the Employees table (attributes, field type, primary key).
- Explain the cardinalities among the tables in the Entity-relationship diagram
- What is the most popular length of stay? How many bookings have been made for that length of stay?
- Typically how many rooms are there in each hotel? Is there huge difference between hotels?
- 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?
- What are the top THREE occupation of the hotel’s customers?
- Which hotel has the highest capacity? What is the capacity? Which hotel has the lowest capacity? What is the capacity?
- Which hotels attract senior customers who age 55 years old or above?
- How many records and attributes in Access were exported to Excel for analysis?
- Explain the formula used to combine the full name of Gary Edwards.
- Explain the formula used to calculate the age of Gary Edwards.
- Explain the formula used to determine the generation category of Gary Edwards?
- How much did Gary Edwards pay for his visit? Explain the formula used to calculate the income from Gary Edwards’ stay.
- Do customers in general prefer the no pet and no smoking rooms? Are the results consistent across different generations? Hint: compare the booking percentage
- Did the hotel with the highest capacity bring in the highest income? If not, which hotel brought in the highest income?
- 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?