Companies

idnameaddress
1Company A123 Main St
2Company B456 Elm St
3Company C789 Oak St
4Company D098 Maple Ave
5Company E543 Pine St

Departments

idname
1Department of Geosciences
2Department of Chemistry
3Department of Biology
4Department of Physics
5Department of Mathematics

EarthSciencesJobs

idjobTitledepartmentIdcompanyId
(→ Departments.id)(→ Companies.id)
1Research Scientist11
2Laboratory Technician12
3Field Geologist23
4Teaching Assistant34
5Data Analyst45

Employees

idfirstNamelastNametitlestartDateendDateearthScienceCareeruniversity
1JohnDoeChemist2010-01-01NoneChemistMIT
2JaneSmithChemist2015-01-01NoneChemistUCLA
3MichaelBrownGeoscientist2010-01-01NoneGeoscientistMIT
4EmilyWhiteGeoscientist2015-01-01NoneGeoscientistStanford
5DavidBlackEngineer2010-01-01NoneEngineerCaltech

Education

employeeIddegreemajorinstitutionyearGraduated
(→ Employees.id)
NonePhDChemistryHarvard2008
NoneMSPhysicsYale2010
NoneBSBiologyPrinceton2012
NoneBAMathematicsColumbia2014
NoneMAComputational ScienceBerkeley2016