Country

CountryIDName
1USA
2UK

City

CityIDNamePopulationForeignKeyID
(→ Country.CountryID)
1New York84190001
2London89820002

EthnicGroup

EthnicGroupIDGroupNamePopulationCityID
(→ City.CityID)
1Hispanic59000001
2White British54000002

AgeGroup

AgeGroupIDLowerBoundUpperBoundTotalPopulationCityID
(→ City.CityID)
101782000001
2182475000002

EducationLevel

EducationLevelIDLevelNameCityIDTotalEnrolledTotalGraduated
(→ City.CityID)
1Primary School120000001500000
2Secondary School115000001200000
3University110000080000
4Postgraduate13000020000
5Vocational Training110000075000

Language

LanguageIDNameNumber_of_speakersPercentage_of_population
1English37900000068.0
2Spanish413000007.5