Scuba_Diving_Centers

idnamelocation
1Blue WaveCancun
2Sea ExplorerMauritius
3Underwater WorldBali
4Aquatic AdventuresHawaii
5Poseidon DiversGreece

Dive_Sites

idsite_nametype
1Great Barrier ReefCoral_Reefs
2Shipwreck CoveWrecks
3Shark AlleyMarine Life
4Turtle BayMarine Life
5The Blue HoleCaverns

Customers

idfirst_namelast_nameemail
1JohnSmithjohnsmith@example.com
2JaneDoejanedoe@example.com
3AliceKingaliceking@example.com
4BobJohnsonbobjohnson@example.com
5CharlieWilliamscharliewilliams@example.com

Bookings

booking_idcustomer_idscuba_center_iddive_site_iddatetime
(→ Customers.id)(→ Scuba_Diving_Centers.id)(→ Dive_Sites.id)
11112023-07-1610:00
22222023-08-0911:00
33332023-09-1712:00
44442023-10-2313:00
55552023-11-3014:00
62212023-08-0911:00
73312023-09-1712:00
84412023-10-2313:00
95512023-11-3014:00