Hostels

idnameaddress
1Hostel A123 Main St
2Hostel B456 Elm St
3Hostel C789 Oak St
4Hostel D012 Pine St
5Hostel E345 Maple Ave

Dormitories

dormitory_idtypecapacity
1Mixed_Dormitory20
2Female Only15
3Mixed_Dormitory30
4Male Only25
5Mixed_Dormitory20
6Female Only10
7Mixed_Dormitory35
8Male Only30
9Mixed_Dormitory20
10Female Only15

Hostels_Dormitories

hostel_dormitory_idhostel_iddormitory_id
(→ Hostels.id)(→ Dormitories.dormitory_id)
111
212
323
424
535
636
747
848
959
10510
1121
1231
1341
1451