## Beach

id | name
--- | ---
1 | White Sands Beach
2 | Sunny Shores Beach

## Beach_Club

id | beach_id | club_name
--- | --- | ---
| (→ Beach.id) |
1 | 1 | Ocean Waves Club
2 | 2 | Seashells Club

## Watersports_Rental

id | beach_club_id | rental_item | price
--- | --- | --- | ---
| (→ Beach_Club.id) |  |
1 | 1 | Surfboard | 35.99
2 | 2 | Kayak | 29.99

## Guest

id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## Reservation

id | guest_id | rental_date | start_time | end_time | num_people
--- | --- | --- | --- | --- | ---
| (→ Guest.id) |  |  |  |
1 | 1 | 2023-06-01 | 10:00 | 17:00 | 8
2 | 2 | 2023-06-02 | 11:00 | 18:00 | 6

## Review

id | reservation_id | rating | comments
--- | --- | --- | ---
| (→ Reservation.id) |  |
1 | 1 | 5 | Great experience!
2 | 2 | 4 | Good time but could have used a little more guidance.