Beaches

idNameAddressPhoneNumberEmail
1White Sands Beach123 Main St555-555-5555whitesand@email.com
2Sunset Shores456 Ocean Blvd555-555-6789sunsets@email.com

Beach_Clubs

idNameLocationOpeningHoursPriceRangeBeach_id
(→ Beaches.id)
1Paradise ClubWhite Sands Beach9am - 6pm$$1
2Ocean View ClubSunset Shores10am - 7pm$$$2

Watersports_Rentals

idItemRentalRateAvailableDaysBeach_id
(→ Beaches.id)
1Kayak20.0Mon - Fri1
2Paddleboard25.0All Days2

Restaurants

idNameCuisineRatingBeach_id
(→ Beaches.id)
1Seaside GrillItalian4.51
2Surfside CafeMexican4.02

Hotels

idNameStar_ratingPriceRangeBeach_id
(→ Beaches.id)
1Oceanfront Inn3Moderate1
2Shoreline Suites4High2

Accommodations

idTypeCapacityAmenitiesBeach_id
(→ Beaches.id)
1Hotel50Pool, WiFi, Parking1
2Vacation Home8No Pets Allowed, Jacuzzi, BBQ2