CleaningProfessionals

idnametypehotel_id
(→ Hotels.id)
1Alice JohnsonHousekeeper1
2Bob BrownHousekeeper2
3Charlie WhiteLaundry Attendant1
4David GreenLaundry Attendant2
5Eva BlueHousekeeper1
6Frank RedLaundry Attendant2

Hotels

idname
1The Grand Hotel
2Park View Inn

Rooms

idroom_numberhotel_id
(→ Hotels.id)
11011
22011
33012
44012
55012

Reservations

idcheckincheckoutroom_idcustomer_name
(→ Rooms.id)
12023-01-012023-01-07101John Doe
22023-01-142023-01-21201Jane Smith

Customers

idfull_nameemailphone
1John Doejohn@example.com123-456-7890
2Jane Smithjane@example.com098-765-4321