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 |