## suburbs

id | name | population
--- | --- | ---
1 | SuburbA | 10000
2 | SuburbB | 8000
3 | SuburbC | 7000
4 | SuburbD | 6000
5 | SuburbE | 5000

## schools

id | school_type
--- | ---
1 | Elementary School
2 | High School
3 | Middle School
4 | College Prep School
5 | Vocational School

## suburbs_schools

suburb_id | school_id
--- | ---
(→ suburbs.id) | (→ schools.id)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5
2 | 1
3 | 1
4 | 1
5 | 1

## houses

id | address | price | size | bedrooms | bathrooms | suburb_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ suburbs.id)
1 | 1 Main St, SuburbA | 500000 | 2000 | 3 | 2 | 1
2 | 2 Side St, SuburbB | 450000 | 1800 | 3 | 2 | 2
3 | 3 Back Alley, SuburbC | 400000 | 1600 | 2 | 2 | 3
4 | 4 Forward Ave, SuburbD | 350000 | 1400 | 2 | 2 | 4
5 | 5 Overlook Blvd, SuburbE | 300000 | 1200 | 2 | 2 | 5

## neighborhoods

id | name | crime_rate
--- | --- | ---
1 | Safe Neighborhood | 1.5
2 | Moderate Crime Area | 3.0
3 | High Crime Zone | 4.5
4 | Very High Crime Region | 5.0
5 | Low Crime Community | 2.0

## suburbs_neighborhoods

suburb_id | neighborhood_id
--- | ---
(→ suburbs.id) | (→ neighborhoods.id)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5