## People

id | firstName | lastName | dateOfBirth | occupation
--- | --- | --- | --- | ---
1 | John | Doe | 1970-06-01 | Engineering
2 | Jane | Smith | 1983-08-15 | Teaching

## SalaryData

personId | salary | hireDate
--- | --- | ---
(→ People.id) |  |
1 | 90000 | 2010-01-01
2 | 60000 | 2012-05-01

## OccupationalStats

occupation | percentageGap | differenceInSalaries | jobSatisfactionIndex
--- | --- | --- | ---
(→ People.occupation) |  |  |
Engineering | 20.0 | 25000 | 80
Teaching | 10.0 | 10000 | 70

## EducationLevel

educationLevel | avgYearsOfEducation | avgAnnualIncome
--- | --- | ---
PhD | 8.0 | 90000
Masters | 6.0 | 75000

## LocationData

locationID | city | state | country | numPeople
--- | --- | --- | --- | ---
1 | New York | NY | USA | 8000000
2 | Los Angeles | CA | USA | 3800000

## CityPopulationByDemographics

locationID | ageRange | gender | ethnicity | population
--- | --- | --- | --- | ---
(→ LocationData.locationID) |  |  |  |
1 | 18-35 | Female | White | 4000000
1 | 36+ | Male | Black | 2500000