suburbs

idnamepopulation
1SuburbA10000
2SuburbB8000
3SuburbC7000
4SuburbD6000
5SuburbE5000

schools

idschool_type
1Elementary School
2High School
3Middle School
4College Prep School
5Vocational School

suburbs_schools

suburb_idschool_id
(→ suburbs.id)(→ schools.id)
11
12
23
24
35
21
31
41
51

houses

idaddresspricesizebedroomsbathroomssuburb_id
(→ suburbs.id)
11 Main St, SuburbA5000002000321
22 Side St, SuburbB4500001800322
33 Back Alley, SuburbC4000001600223
44 Forward Ave, SuburbD3500001400224
55 Overlook Blvd, SuburbE3000001200225

neighborhoods

idnamecrime_rate
1Safe Neighborhood1.5
2Moderate Crime Area3.0
3High Crime Zone4.5
4Very High Crime Region5.0
5Low Crime Community2.0

suburbs_neighborhoods

suburb_idneighborhood_id
(→ suburbs.id)(→ neighborhoods.id)
11
12
23
24
35