FIT5137 M-Stay Residential service

FIT5137 Assignment 2 -S2 2024  (Weight = 40%)

Due - Friday, 20 September 2024, 4:30 PM

General Information and Submission

o This is an individual assignment.

o Submission method: Submission is online through Moodle.

o Penalty for late submission: 5% deduction for each day.

o Assignment FAQ: There is an Assignment Frequently Asked Questions page set up for the Assignment 2 on EdStem Forum.

Problem Description

M-Stay is a residential service that offers homestay and rental services to Monash students and staff around Melbourne. The company has an existing operational database that maintains and stores all of the business transactions information (e.g. properties, hosts, listings, booking, etc.) required for the management's daily operation. As the business grows, M-Stay has decided to build a Data Warehouse to improve their analysis and work efficiency. However, since the staff at M-Stay have limited Business Intelligence and Data Warehouse knowledge, they have decided to hire you to design, develop and quickly generate BI reports from a Data Warehouse.

The operational database tables can be found at the MStay account. You can, for example, execute the following query:

select * from MStay.<table_name>;

The data definition of each table in MStay is as follows: