## Beaches

id | Name | Address | PhoneNumber | Email
--- | --- | --- | --- | ---
1 | White Sands Beach | 123 Main St | 555-555-5555 | whitesand@email.com
2 | Sunset Shores | 456 Ocean Blvd | 555-555-6789 | sunsets@email.com

## Beach_Clubs

id | Name | Location | OpeningHours | PriceRange | Beach_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Beaches.id)
1 | Paradise Club | White Sands Beach | 9am - 6pm | $$ | 1
2 | Ocean View Club | Sunset Shores | 10am - 7pm | $$$ | 2

## Restaurants

id | Name | Cuisine | Rating | Beach_id
--- | --- | --- | --- | ---
|  |  |  | (→ Beaches.id)
1 | Seaside Grill | Italian | 4.5 | 1
2 | Surfside Cafe | Mexican | 4.0 | 2

## Hotels

id | Name | Star_rating | PriceRange | Beach_id
--- | --- | --- | --- | ---
|  |  |  | (→ Beaches.id)
1 | Oceanfront Inn | 3 | Moderate | 1
2 | Shoreline Suites | 4 | High | 2

## Accommodations

id | Type | Capacity | Amenities | Beach_id
--- | --- | --- | --- | ---
|  |  |  | (→ Beaches.id)
1 | Hotel | 50 | Pool, WiFi, Parking | 1
2 | Vacation Home | 8 | No Pets Allowed, Jacuzzi, BBQ | 2

## Watersports_Rentals

id | name | Item | RentalRate | AvailableDays | Beach_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Beaches.id)
1 | AquaAdventures Rentals | Kayak | 20.0 | Mon - Fri | 1
2 | WaveRider Rentals | Paddleboard | 25.0 | All Days | 2