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 |