CleaningProfessionals
| id | name | type | hotel_id |
| | | (→ Hotels.id) |
| 1 | Alice Johnson | Housekeeper | 1 |
| 2 | Bob Brown | Housekeeper | 2 |
| 3 | Charlie White | Laundry Attendant | 1 |
| 4 | David Green | Laundry Attendant | 2 |
| 5 | Eva Blue | Housekeeper | 1 |
| 6 | Frank Red | Laundry Attendant | 2 |
Hotels
| id | name |
| 1 | The Grand Hotel |
| 2 | Park View Inn |
Rooms
| id | room_number | hotel_id |
| | (→ Hotels.id) |
| 1 | 101 | 1 |
| 2 | 201 | 1 |
| 3 | 301 | 2 |
| 4 | 401 | 2 |
| 5 | 501 | 2 |
Reservations
| id | checkin | checkout | room_id | customer_name |
| | | (→ Rooms.id) | |
| 1 | 2023-01-01 | 2023-01-07 | 101 | John Doe |
| 2 | 2023-01-14 | 2023-01-21 | 201 | Jane Smith |
Customers
| id | full_name | email | phone |
| 1 | John Doe | john@example.com | 123-456-7890 |
| 2 | Jane Smith | jane@example.com | 098-765-4321 |