Cleaning_Professionals

IDNamePositionHotel_ID
1John DoeHousekeeper1
2Jane SmithHousekeeper2
3Mike JohnsonLaundry Attendant1
4Emily DavisLaundry Attendant2
5William BrownRoom Attendant3
6Anna WilsonPorter4
7David MillerManager1
8Sarah JonesAssistant Manager2

Rooms

IDNumberTypeFloorHotel_ID
1101Deluxe Suite11
2202Standard Room21
3303Family Suite32
4404Executive Room43
5505Superior Room54
6606Budget Room61
7707Standard Suite72
8808Economy Room83

Hotels

IDNameLocationManager_Name
1The Grand HotelDowntownDavid Miller
2City Center InnUptownSarah Jones
3Waterfront ViewSeasideNone
4Cozy InnSuburbiaNone

Services

IDService_TypeDescriptionPrice
1AccommodationComfortable stay at our hotel.99.99
2BreakfastFull English breakfast included.15.0
3TransportShuttle service available.20.0
4EntertainmentLive music on weekends.10.0
5Fitness CentreState of the art gymnasium.5.0