| 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 |
| id | name |
|---|---|
| 1 | Department of Geosciences |
| 2 | Department of Chemistry |
| 3 | Department of Biology |
| 4 | Department of Physics |
| 5 | Department of Mathematics |
| 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 |
| 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 |
| 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 |