Hotel
| id | name | address | price |
| | | (→ PriceTable.value) |
| 1 | Grand Plaza | 123 Main St | 50.0 |
| 2 | Ritz Carlton | 456 Central Ave | 100.0 |
Youth_hostel
| id | name | address | price |
| | | (→ PriceTable.value) |
| 1 | Backpacker Inn | 789 Pine St | 50.0 |
| 2 | Budget Lodge | 987 Oak St | 75.0 |
Room
| id | hotel_id | type | occupancy | price |
| (→ Hotel.id) | | | (→ PriceTable.value) |
| 1 | 1 | Deluxe Suite | 2 | 75.0 |
| 2 | 2 | Executive Suite | 3 | 150.0 |
| 3 | 1 | Standard Double | 2 | 50.0 |
| 4 | 2 | Economy Twin | 2 | 75.0 |
Booking
| id | room_id | customer_name | checkin | checkout | status |
| (→ Room.id) | | | | |
| 1 | 1 | John Doe | 2023-01-01 10:00:00 | 2023-01-03 10:00:00 | Confirmed |
| 2 | 2 | Jane Smith | 2023-01-05 10:00:00 | 2023-01-07 10:00:00 | Confirmed |
PriceTable
| value |
| 50.0 |
| 75.0 |
| 100.0 |
| 150.0 |
| 200.0 |