Cruise_Ships

ShipIDNameCapacity
1Ocean Jewel2000
2Mediterranean Treasure3000
3Caribbean Dream4000
4Atlantic Explorer3500
5Pacific Wanderer2500

All_Inclusive_Resorts

ResortIDNameLocation
1Tropical ParadiseBahamas
2Beachside BlissCosta Rica
3Mountain RetreatColorado
4Desert OasisArizona
5Lakeside HavenWisconsin

Customers

CustomerIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceJohnsonalice.johnson@example.com
4BobWilliamsbob.williams@example.com
5EmilyDavisemily.davis@example.com

Activities

ActivityIDDescription
1Dance Class
2Scuba Diving
3Yoga
4Golf
5Hiking

Bookings

BookingIDCustomerIDShipIDResortID
(→ Customers.CustomerID)(→ Cruise_Ships.ShipID)(→ All_Inclusive_Resorts.ResortID)
1111
2222
3333
4444
5555

Participation

ParticipantIDBookingIDActivityID
(→ Bookings.BookingID)(→ Activities.ActivityID)
111
212
323
434
545