Countries

CountryIDNamePopulation
1USA328000000
2Canada37600000

States

StateIDCountryIDName
(→ Countries.CountryID)
11California
21New York
32Quebec
42Ontario

Cities

CityIDStateIDName
(→ States.StateID)
11Los Angeles
21San Francisco
31Chicago
42Montreal
52Toronto

People

PersonIDAgeSexOccupationResidenceCityId
(→ Cities.CityID)
130MEngineer1
245FDoctor2
350MTeacher3
425FLawyer4
535MAccountant5

DiabetesData

DataIDPercentage_Of_DiabeticsDiabetic_CountPopulationCityId
(→ Cities.CityID)
15500100001
23300100002
34400100003
46600100004
52200100005

HealthCareFacilities

FacilityIDNameAddressPhoneNumberCityId
(→ Cities.CityID)
1St. John Hospital123 Main St.555-12341
2Mount Sinai Medical Center456 Elm St.555-56782
3Sunnyview Hospital789 Oak St.555-90123
4Riverside Clinic101 Pine St.555-13574
5Community Care Center202 Fir St.555-14155