| ResortID | Name | Location |
|---|---|---|
| 1 | Paradise Beach | California |
| 2 | Sunset Shores | Florida |
| 3 | Tropical Paradise | Hawaii |
| 4 | Seashell Cove | Caribbean |
| 5 | Wave Rider Bay | Australia |
| SportID | Name | Description |
|---|---|---|
| 1 | Surfing | A water sport involving the riding of ocean waves on a surfboard. |
| 2 | Snorkeling | An activity where you swim underwater while wearing a mask and fins. |
| 3 | Scuba Diving | An underwater diving activity that allows divers to breathe underwater using a tank containing compressed air. |
| 4 | Kayaking | Paddling a small narrow boat on rivers or coastal waters. |
| 5 | Swimming | The act of propelling oneself through water by moving the limbs. |
| ResortID | SportID |
|---|---|
| (→ Beach_Resorts.ResortID) | (→ Water_Sports.SportID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |