Mountain_Resorts

ResortIDNameLocationNumOfRooms
1Alpine LodgeColorado Mountains100
2Aspen Ski ChaletColorado Mountains200
3Rocky Peak InnUtah Mountains300
4High Country RetreatMontana Mountains400
5Peak View MotelCalifornia Mountains500

Winter_Sports

SportIDNameDescription
1SnowboardingA thrilling snow sport that involves descending a snow-covered slope on a snowboard
2Cross-Country SkiingA form of skiing where participants travel over long distances across snow-covered terrain
3Downhill SkiingA popular alpine winter sport involving sliding down snow-covered slopes on skis with fixed bindings to boots
4Ice SkatingA recreational activity where people wear ice skates to glide on an ice surface
5Ice HockeyAn athletic team sport played on ice, in which skaters use sticks to shoot a flat puck into the opposing goal

Mountain_Resorts_Winter_Sports

ResortIDSportID
(→ Mountain_Resorts.ResortID)(→ Winter_Sports.SportID)
11
22
33
44
55
21
31
41
51