## RoomAmenities

amenID | amenName | amenCost
--- | --- | ---
1 | Free WiFi | 0.0
2 | Parking | 10.99
3 | Gym Access | 2.5
4 | Breakfast Included | 8.75
5 | Laundry Service | 3.0

## Guests

guestID | firstName | lastName | email | phoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +1-555-123-4567
2 | Jane | Smith | jane@example.com | +1-555-987-6543
3 | Michael | Brown | michael@example.com | +1-555-321-9876
4 | Emily | White | emily@example.com | +1-555-135-7890
5 | David | Black | david@example.com | +1-555-456-1234

## GuestHouses

houseID | houseName | location | capacity | pricePerNight
--- | --- | --- | --- | ---
1 | Cozy Inn | New York City | 10 | 150.0
2 | Urban Retreat | Los Angeles | 15 | 200.0
3 | Mountain Lodge | Denver | 8 | 180.0
4 | Beachfront Paradise | Miami Beach | 12 | 250.0
5 | City Center Suite | Chicago | 6 | 175.0

## Suites

suiteType
Standard Suite
Deluxe Suite
Executive Suite
Family Suite

## GuestHouseSuites

guesthouseID | suiteType
--- | ---
(→ GuestHouses.houseID) | (→ Suites.suiteType)
1 | Standard Suite
1 | Family Suite
2 | Deluxe Suite
2 | Family Suite
3 | Standard Suite
3 | Family Suite
4 | Deluxe Suite
4 | Executive Suite
5 | Deluxe Suite
5 | Family Suite
3 | Deluxe Suite
4 | Family Suite
5 | Standard Suite