Beach_Resorts

ResortIDNameLocation
1Paradise BeachCalifornia
2Sunset ShoresFlorida
3Tropical ParadiseHawaii
4Seashell CoveCaribbean
5Wave Rider BayAustralia

Water_Sports

SportIDNameDescription
1SurfingA water sport involving the riding of ocean waves on a surfboard.
2SnorkelingAn activity where you swim underwater while wearing a mask and fins.
3Scuba DivingAn underwater diving activity that allows divers to breathe underwater using a tank containing compressed air.
4KayakingPaddling a small narrow boat on rivers or coastal waters.
5SwimmingThe act of propelling oneself through water by moving the limbs.

Beach_Resorts_Water_Sports

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