A travel company would like to analyze its data in order to plan better promotional campaigns with its customers. More specifically, she would like to analyze the number and number of sales based on:
✓ Destination: hotel, city, country, region, region category (example: seaside, alpine. etc.), destination category (example: family or not), hotel category (ex: 1-4 stars);
✓ Date of purchase: day of the year, day of the week, month, year, tourist season (eg: low or high season);
✓Client: age group, sex, address, type of buyer (eg: new, recurring, etc.);
1. Provide a star schema which will allow the company to do these analyzes
2. Clearly identify the primary and foreign keys of fact and dimension tables;
3. Identify, for each dimension table, a hierarchy of levels of granularity (e.g.. attribute!
attribute2...);