## Locations

LocationID | Name
--- | ---
1 | Snowdonia
2 | Lake District

## Accommodations

AccommodationID | Type
--- | ---
1 | Glamping Pod
2 | Treehouse

## Rooms

RoomID | LocationID | AccommodationID
--- | --- | ---
| (→ Locations.LocationID) | (→ Accommodations.AccommodationID)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 1
4 | 2 | 2

## Customers

CustomerID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john@example.com
2 | Jane | Smith | jane@example.com

## Bookings

BookingID | RoomID | CustomerID | CheckInDate | CheckOutDate
--- | --- | --- | --- | ---
| (→ Rooms.RoomID) | (→ Customers.CustomerID) |  |
1 | 1 | 1 | 2022-07-01 | 2022-07-08
2 | 2 | 2 | 2022-07-15 | 2022-07-22
3 | 3 | 1 | 2022-08-01 | 2022-08-08
4 | 4 | 2 | 2022-08-15 | 2022-08-22