Discussion:
Task:
You have been asked to design a star schema for a large hotel chain. Review the information package given for a hotel chain in Figure. Use this information package to design the STAR schema.
Problem:
- Draw the star schema.
- List the attributes for each table.
- Designate a primary key for each table.
Dimensions
|
Time
|
Hotel
|
Room
TYPe
|
|
|
|
|
Year
|
Hotel Line
|
Room
Type
|
|
|
|
|
Quarter
|
Branch
Name
|
Room
Size
|
|
|
|
|
Month
|
Branch
Code
|
Number
of Beds
|
|
|
|
|
Date
|
Region
|
Type of
Bad
|
|
|
|
|
Day of
Week
|
Address
|
Max.
Occupants
|
|
|
|
|
Day of
Month
|
City/State/
Zip
|
Suite
|
|
|
|
|
Holiday
Flag
|
Consume-
lion Year
|
Refnge-
rotor
|
|
|
|
|
|
Renova-
lion Year
|
Kichen-
nate
|
|
|
|
|
Facts: Occupied Rooms, Vacant Rooms. Unavailable Rooms, Number of Occupants, Revenue
|
Figure Information package: hotel occupancy.