## Companies

id | name | address
--- | --- | ---
1 | Company A | 123 Main St
2 | Company B | 456 Elm St
3 | Company C | 789 Oak St
4 | Company D | 098 Maple Ave
5 | Company E | 543 Pine St

## Departments

id | name
--- | ---
1 | Department of Geosciences
2 | Department of Chemistry
3 | Department of Biology
4 | Department of Physics
5 | Department of Mathematics

## EarthSciencesJobs

id | jobTitle | departmentId | companyId
--- | --- | --- | ---
|  | (→ Departments.id) | (→ Companies.id)
1 | Research Scientist | 1 | 1
2 | Laboratory Technician | 1 | 2
3 | Field Geologist | 2 | 3
4 | Teaching Assistant | 3 | 4
5 | Data Analyst | 4 | 5

## Employees

id | firstName | lastName | title | startDate | endDate | university
--- | --- | --- | --- | --- | --- | ---
1 | John | Doe | Chemist | 2010-01-01 | None | MIT
2 | Jane | Smith | Chemist | 2015-01-01 | None | UCLA
3 | Michael | Brown | Geoscientist | 2010-01-01 | None | MIT
4 | Emily | White | Geoscientist | 2015-01-01 | None | Stanford
5 | David | Black | Engineer | 2010-01-01 | None | Caltech

## Education

employeeId | degree | major | institution | yearGraduated
--- | --- | --- | --- | ---
(→ Employees.id) |  |  |  |
None | PhD | Chemistry | Harvard | 2008
None | MS | Physics | Yale | 2010
None | BS | Biology | Princeton | 2012
None | BA | Mathematics | Columbia | 2014
None | MA | Computational Science | Berkeley | 2016