Chalets

IdNameLocationCapacity
1Chalet AAlps10
2Chalet BMountains8
3Chalet CBeachside6
4Chalet DCity Centre12
5Chalet ELakeside10

Cabins

IdNameLocationCapacity
1Cabin XForest4
2Cabin YDesert3
3Cabin ZRiverbank5
4Cabin WCoast7
5Cabin VHills6

Accommodations

IdTypePrice_per_night
(→ Chalets.Name)
1Chalet A200.0
2Chalet B300.0
3Cabin X200.0
4Cabin Y300.0
5Chalet C250.0

Bookings

IdGuest_nameCheckInCheckOutAccommodation_idTotal_price
(→ Accommodations.Id)
1John Doe2023-01-012023-01-051None
2Jane Smith2023-01-102023-01-142None
3Michael Johnson2023-01-152023-01-193None
4Emma Wilson2023-01-202023-01-244None
5David Brown2023-01-252023-01-295None