| CountryID | Name | Population |
|---|---|---|
| 1 | USA | 328000000 |
| 2 | Canada | 37600000 |
| StateID | CountryID | Name |
|---|---|---|
| (→ Countries.CountryID) | ||
| 1 | 1 | California |
| 2 | 1 | New York |
| 3 | 2 | Quebec |
| 4 | 2 | Ontario |
| CityID | StateID | Name |
|---|---|---|
| (→ States.StateID) | ||
| 1 | 1 | Los Angeles |
| 2 | 1 | San Francisco |
| 3 | 1 | Chicago |
| 4 | 2 | Montreal |
| 5 | 2 | Toronto |
| 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 |
| 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 |
| 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 |