## Chalets

Id | Name | Location | Capacity
--- | --- | --- | ---
1 | Chalet A | Alps | 10
2 | Chalet B | Mountains | 8
3 | Chalet C | Beachside | 6
4 | Chalet D | City Centre | 12
5 | Chalet E | Lakeside | 10

## Cabins

Id | Name | Location | Capacity
--- | --- | --- | ---
1 | Cabin X | Forest | 4
2 | Cabin Y | Desert | 3
3 | Cabin Z | Riverbank | 5
4 | Cabin W | Coast | 7
5 | Cabin V | Hills | 6

## Accommodations

Id | Type | Price_per_night
--- | --- | ---
| (→ Chalets.Name) |
1 | Chalet A | 200.0
2 | Chalet B | 300.0
3 | Cabin X | 200.0
4 | Cabin Y | 300.0
5 | Chalet C | 250.0

## Bookings

Id | Guest_name | CheckIn | CheckOut | Accommodation_id | Total_price
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Accommodations.Id) |
1 | John Doe | 2023-01-01 | 2023-01-05 | 1 | None
2 | Jane Smith | 2023-01-10 | 2023-01-14 | 2 | None
3 | Michael Johnson | 2023-01-15 | 2023-01-19 | 3 | None
4 | Emma Wilson | 2023-01-20 | 2023-01-24 | 4 | None
5 | David Brown | 2023-01-25 | 2023-01-29 | 5 | None