and 4 others joined a min ago.
1
21kviews
Design star & snowflake schema for "Hotel Occupancy" considering dimensions like Time, Hotel, Room, etc.
1 Answer
3
2.6kviews
written 5.1 years ago by
teamques10
★ 65k
|
• modified 5.1 years ago |
Star scheme = For hotel occupancy.
Facts : No. of occupied rooms
No. of vacant rooms revenue
Dimensions : Time, Hotel, Room, Customer,
Dimension hierarchy :
Time : Data, day of week, day of month, week, month, quarter, half, year, holiday.
Hotel : Hotel name, hotel type, start rating, regime, …
and 2 others joined a min ago.
ADD COMMENT
EDIT
Please log in to add an answer.