| ShipID | Name | Capacity |
|---|---|---|
| 1 | Ocean Jewel | 2000 |
| 2 | Mediterranean Treasure | 3000 |
| 3 | Caribbean Dream | 4000 |
| 4 | Atlantic Explorer | 3500 |
| 5 | Pacific Wanderer | 2500 |
| ResortID | Name | Location |
|---|---|---|
| 1 | Tropical Paradise | Bahamas |
| 2 | Beachside Bliss | Costa Rica |
| 3 | Mountain Retreat | Colorado |
| 4 | Desert Oasis | Arizona |
| 5 | Lakeside Haven | Wisconsin |
| CustomerID | FirstName | LastName | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| 3 | Alice | Johnson | alice.johnson@example.com |
| 4 | Bob | Williams | bob.williams@example.com |
| 5 | Emily | Davis | emily.davis@example.com |
| ActivityID | Description |
|---|---|
| 1 | Dance Class |
| 2 | Scuba Diving |
| 3 | Yoga |
| 4 | Golf |
| 5 | Hiking |
| BookingID | CustomerID | ShipID | ResortID |
|---|---|---|---|
| (→ Customers.CustomerID) | (→ Cruise_Ships.ShipID) | (→ All_Inclusive_Resorts.ResortID) | |
| 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 2 |
| 3 | 3 | 3 | 3 |
| 4 | 4 | 4 | 4 |
| 5 | 5 | 5 | 5 |
| ParticipantID | BookingID | ActivityID |
|---|---|---|
| (→ Bookings.BookingID) | (→ Activities.ActivityID) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 4 | 3 | 4 |
| 5 | 4 | 5 |