Guest

idnameemail
1John Doejohndoe@example.com
2Jane Smithjanesmith@example.com
3Alice Johnsonalicejohnson@example.com
4Bob Brownbobbrown@example.com
5Charlie Davischarliedavis@example.com

Vacation

idvacation_optionprice
(→ VacationType.type)
1Cruise Ship2000.0
2All-Inclusive Resort3000.0

Activity

idactivities
1Dance Class
2Hiking Tour
3Beach Volleyball
4Snorkeling
5Wine Tasting

Booking

idguest_idvacation_idactivity_idcheckincheckout
(→ Guest.id)(→ Vacation.id)(→ Activity.id)
11112023-01-01 10:00:002023-01-07 10:00:00
22122023-01-10 10:00:002023-01-16 10:00:00
33212023-02-01 10:00:002023-02-07 10:00:00
44232023-02-10 10:00:002023-02-16 10:00:00
55142023-03-01 10:00:002023-03-07 10:00:00

VacationType

typedescription
Cruise ShipNone
All-Inclusive ResortNone

Hotel

idhotel_nameaddressphone_numberrating
1Grand Ocean View123 Beach St.+12345678904.5
2Coastal Paradise456 Coast Rd.+9876543214.0