## Hostels

id | name | address
--- | --- | ---
1 | Hostel A | 123 Main St
2 | Hostel B | 456 Elm St
3 | Hostel C | 789 Oak St
4 | Hostel D | 012 Pine St
5 | Hostel E | 345 Maple Ave

## Dormitories

dormitory_id | type | capacity
--- | --- | ---
1 | Mixed_Dormitory | 20
2 | Female Only | 15
3 | Mixed_Dormitory | 30
4 | Male Only | 25
5 | Mixed_Dormitory | 20
6 | Female Only | 10
7 | Mixed_Dormitory | 35
8 | Male Only | 30
9 | Mixed_Dormitory | 20
10 | Female Only | 15

## Hostels_Dormitories

hostel_dormitory_id | hostel_id | dormitory_id
--- | --- | ---
| (→ Hostels.id) | (→ Dormitories.dormitory_id)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 2 | 4
5 | 3 | 5
6 | 3 | 6
7 | 4 | 7
8 | 4 | 8
9 | 5 | 9
10 | 5 | 10
11 | 2 | 1
12 | 3 | 1
13 | 4 | 1
14 | 5 | 1