RoomAmenities

amenIDamenNameamenCost
1Free WiFi0.0
2Parking10.99
3Gym Access2.5
4Breakfast Included8.75
5Laundry Service3.0

Guests

guestIDfirstNamelastNameemailphoneNumber
1JohnDoejohn@example.com+1-555-123-4567
2JaneSmithjane@example.com+1-555-987-6543
3MichaelBrownmichael@example.com+1-555-321-9876
4EmilyWhiteemily@example.com+1-555-135-7890
5DavidBlackdavid@example.com+1-555-456-1234

GuestHouses

houseIDhouseNamelocationcapacitypricePerNight
1Cozy InnNew York City10150.0
2Urban RetreatLos Angeles15200.0
3Mountain LodgeDenver8180.0
4Beachfront ParadiseMiami Beach12250.0
5City Center SuiteChicago6175.0

Suites

suiteType
Standard Suite
Deluxe Suite
Executive Suite
Family Suite

GuestHouseSuites

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