AgeGroups

IDName
10-9
210-19
320-29
430-39
540-49

BirthYears

YearNumber_Of_BirthsCrude_Birth_RateCity
201810007.6New York
201910508.1Los Angeles
202011008.6Chicago
202111509.1Houston
202212009.6Phoenix

Regions

RegionNamePopulationCount
Northeast2000000
Midwest1500000
South1000000
West1200000
Other500000

Cities

CityNameRegionName
(→ Regions.RegionName)
New YorkNortheast
Los AngelesWest
ChicagoMidwest
HoustonSouth
PhoenixWest

AgeGroupPopulations

AgeGroupIDYearCityNameTotalPopulation
(→ AgeGroups.ID)(→ BirthYears.Year)(→ Cities.CityName)
12018New York100000
12018Los Angeles80000
12018Chicago70000
12018Houston60000
12018Phoenix50000

EducationLevels

LevelPercentage
High School Diploma25
Some College30
Associate Degree10
Bachelor's Degree35
Graduate Degree15

CityEducationStats

CityNameLevelPercentage
(→ Cities.CityName)(→ EducationLevels.Level)
New YorkHigh School Diploma27
Los AngelesSome College32
ChicagoAssociate Degree11
HoustonBachelor's Degree36
PhoenixGraduate Degree16