Locations

LocationIDName
1Snowdonia
2Lake District

Accommodations

AccommodationIDType
1Glamping Pod
2Treehouse

Rooms

RoomIDLocationIDAccommodationID
(→ Locations.LocationID)(→ Accommodations.AccommodationID)
111
212
321
422

Customers

CustomerIDFirstNameLastNameEmail
1JohnDoejohn@example.com
2JaneSmithjane@example.com

Bookings

BookingIDRoomIDCustomerIDCheckInDateCheckOutDate
(→ Rooms.RoomID)(→ Customers.CustomerID)
1112022-07-012022-07-08
2222022-07-152022-07-22
3312022-08-012022-08-08
4422022-08-152022-08-22