Chalets

idNameAccommodationPrice_Per_NightCapacity
1AshfordChalet200.06
2BeechwoodChalet180.04
3CanterburyChalet300.08
4DurhamCabin200.02
5ExeterCabin190.04
6GloucesterCabin220.06
7HampshireChalet250.010
8IsleOfWightCabin270.08

Cabins

idNameAccommodationPrice_Per_NightCapacity
1JerseyCabin200.02
2LancasterCabin180.04
3LeicesterCabin300.08
4NewcastleChalet200.06
5NottinghamChalet190.04
6ShrewsburyChalet220.06
7SomersetChalet250.010
8StaffordshireCabin270.08

Guests

idFirstNameLastNameContactNumberEmailAddress
1JohnSmith+123456789johnsmith@example.com
2JaneDoe+987654321janedoe@example.com

Bookings

idGuestIdStartDateEndDateAccommodationType
(→ Guests.id)
112022-01-012022-01-07Chalet
222022-01-012022-01-07Cabin
332022-01-152022-01-22Chalet
442022-01-152022-01-22Cabin