| id | name | location |
|---|---|---|
| 1 | Blue Wave | Cancun |
| 2 | Sea Explorer | Mauritius |
| 3 | Underwater World | Bali |
| 4 | Aquatic Adventures | Hawaii |
| 5 | Poseidon Divers | Greece |
| id | site_name | type |
|---|---|---|
| 1 | Great Barrier Reef | Coral_Reefs |
| 2 | Shipwreck Cove | Wrecks |
| 3 | Shark Alley | Marine Life |
| 4 | Turtle Bay | Marine Life |
| 5 | The Blue Hole | Caverns |
| id | first_name | last_name | |
|---|---|---|---|
| 1 | John | Smith | johnsmith@example.com |
| 2 | Jane | Doe | janedoe@example.com |
| 3 | Alice | King | aliceking@example.com |
| 4 | Bob | Johnson | bobjohnson@example.com |
| 5 | Charlie | Williams | charliewilliams@example.com |
| booking_id | customer_id | scuba_center_id | dive_site_id | date | time |
|---|---|---|---|---|---|
| (→ Customers.id) | (→ Scuba_Diving_Centers.id) | (→ Dive_Sites.id) | |||
| 1 | 1 | 1 | 1 | 2023-07-16 | 10:00 |
| 2 | 2 | 2 | 2 | 2023-08-09 | 11:00 |
| 3 | 3 | 3 | 3 | 2023-09-17 | 12:00 |
| 4 | 4 | 4 | 4 | 2023-10-23 | 13:00 |
| 5 | 5 | 5 | 5 | 2023-11-30 | 14:00 |
| 6 | 2 | 2 | 1 | 2023-08-09 | 11:00 |
| 7 | 3 | 3 | 1 | 2023-09-17 | 12:00 |
| 8 | 4 | 4 | 1 | 2023-10-23 | 13:00 |
| 9 | 5 | 5 | 1 | 2023-11-30 | 14:00 |