## Countries

CountryID | Name | Population
--- | --- | ---
1 | USA | 328000000
2 | Canada | 37600000

## States

StateID | CountryID | Name
--- | --- | ---
| (→ Countries.CountryID) |
1 | 1 | California
2 | 1 | New York
3 | 2 | Quebec
4 | 2 | Ontario

## Cities

CityID | StateID | Name
--- | --- | ---
| (→ States.StateID) |
1 | 1 | Los Angeles
2 | 1 | San Francisco
3 | 1 | Chicago
4 | 2 | Montreal
5 | 2 | Toronto

## People

PersonID | Age | Sex | Occupation | ResidenceCityId
--- | --- | --- | --- | ---
|  |  |  | (→ Cities.CityID)
1 | 30 | M | Engineer | 1
2 | 45 | F | Doctor | 2
3 | 50 | M | Teacher | 3
4 | 25 | F | Lawyer | 4
5 | 35 | M | Accountant | 5

## DiabetesData

DataID | Percentage_Of_Diabetics | Diabetic_Count | Population | CityId
--- | --- | --- | --- | ---
|  |  |  | (→ Cities.CityID)
1 | 5 | 500 | 10000 | 1
2 | 3 | 300 | 10000 | 2
3 | 4 | 400 | 10000 | 3
4 | 6 | 600 | 10000 | 4
5 | 2 | 200 | 10000 | 5

## HealthCareFacilities

FacilityID | Name | Address | PhoneNumber | CityId
--- | --- | --- | --- | ---
|  |  |  | (→ Cities.CityID)
1 | St. John Hospital | 123 Main St. | 555-1234 | 1
2 | Mount Sinai Medical Center | 456 Elm St. | 555-5678 | 2
3 | Sunnyview Hospital | 789 Oak St. | 555-9012 | 3
4 | Riverside Clinic | 101 Pine St. | 555-1357 | 4
5 | Community Care Center | 202 Fir St. | 555-1415 | 5