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 |