Hotels

idnameaddressphoneNumber
1The Grand Hotel123 Main St+1234567890
2Park Plaza Inn456 Market St+0987654321
3Riverview Suites789 River Rd+1112223333
4Sunset Beach Resort321 Ocean Blvd+4445556667
5Mountain Retreat Lodge654 Mountain Way+7778889990

HouseKeepers

idfirstNamelastNameemailhireDatesalaryhotelId
(→ Hotels.id)
1JohnDoejohn.doe@example.com2021-01-0135000.01
2JaneSmithjane.smith@example.com2021-02-0138000.02
3AliceBrownalice.brown@example.com2021-03-0140000.03
4MikeJohnsonmike.johnson@example.com2021-04-0136000.04
5EmmaWilliamsemma.williams@example.com2021-05-0139000.05

LaundryAttendants

idfirstNamelastNameemailhireDatesalaryhotelId
(→ Hotels.id)
1DavidMartindavid.martin@example.com2021-01-0132000.01
2LucyTaylorlucy.taylor@example.com2021-02-0133000.02
3CharlieThompsoncharlie.thompson@example.com2021-03-0134000.03
4GraceMillergrace.miller@example.com2021-04-0135000.04
5SamanthaWrightsamantha.wright@example.com2021-05-0136000.05

Rooms

idnumberhotelIdhouseKeeperIdlaundryAttendantId
(→ Hotels.id)(→ HouseKeepers.id)(→ LaundryAttendants.id)
1101111
2201222
3301333
4401444
5501555
6102111
7202222
8302333
9402444
10502555