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 |