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 |