Vacation rentals would like you to develop a data warehouse that can be used to

Question

Vacation rentals would like you to develop a data warehouse that can be used to better analyze and understand their operations. They are interested in producing a variety of reports based on the time of the year apartments are rented, the daily rental rates they were able to negotiate, the total rental revenue per rental, and the number of days each apartment is rented at a time, as they seek to understand what drives rental patterns. They also need to produce reports that are tailored by property, or by owner, or by apartment type, facility, etc. Finally, they would like to keep track of renovations over time, as the company is interested in looking at the effects of renovations on their different outcomes of interest (to assess the degree to which spending money on renovations, and how often, is a sound idea). Required Using the description provided and the data model of the current rental system, design a dimensional model that will satisfy the informational needs of Vacation Rentals. Assume that all information that is currently included in their data model is relevant for analysis purposes (i.e., it should all find its way into the dimensional model you create). Document any major design decision (e.g., your handling of SCD apartment amenities, etc.). Your deliverable for this assignment is a star schema that includes all relevant tables and attributes, as well as appropriate foreign keys and relationships, etc. State any assumptions you make. Your design should be able to provide Vacation Rentals with the kinds of reports that are outlined in the description.

Explanation / Answer

#include 11 #include 12 using namespace std; 13 14 int main(){ 15 16 ifstream file; 17 18 // Creates a readable 32 bit int variable named "a" 19 uint32_t a; 20 21 // Binary file will open for read functionality 22 23 file.open("threesData.bin",ios::binary | ios::in); 24 25 // User prompt when file doesnt open 26 27 if (!file) 28 { 29 cout

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.