Cruise_Ship
id | name | capacity | destination | cruise_start_date | cruise_end_date | activities |
1 | Majestic Ocean | 3000 | Caribbean | 2023-06-01 | 2023-06-07 | Dance Class |
2 | Grand Voyage | 2500 | Alaska | 2023-05-15 | 2023-05-28 | Bingo Night |
All_Inclusive_Resort
id | name | location | star_rating | number_of_rooms | activities |
1 | Paradise Beach | Hawaii | 4 | 150 | Dance Class |
2 | Sunset Oasis | Mexico | 3 | 200 | Yoga Session |
Customer
id | firstName | lastName | email | phoneNumber | preferredLanguage |
1 | John | Smith | johnsmith@example.com | +1234567890 | English |
2 | Jane | Doe | janedoe@example.com | +9876543210 | French |
Employee
id | firstName | lastName | position | yearsOfExperience | skill |
1 | Tom | Anderson | Receptionist | 5 | Customer Service |
2 | Laura | Williams | Chef | 8 | Cooking |
Booking
bookingId | customerId | cruiseOrResort | checkinDate | checkoutDate |
| (→ Customer.id) | | | |
1 | 1 | 1 | 2023-06-01 | 2023-06-07 |
2 | 2 | 0 | 2023-06-10 | 2023-06-20 |