University

idname
1MIT
2Stanford

Chemist

iduniversity_idfirstNamelastNamefieldOfStudy
(→ University.id)
11JohnDoeOrganic Chemistry
21JaneSmithInorganic Chemistry
32AliceBrownPhysical Chemistry
42BobWhiteAnalytical Chemistry

Geoscientist

iduniversity_idfirstNamelastNamefieldOfStudy
(→ University.id)
11TomJacksonGeology
21EmmaNelsonSeismology
32MikeGarciaPaleontology
42LisaHillOceanography

Employee

idemployeeNumberfirstNamelastNamehireDatejobTitlesalarydepartmentIDmanagerID
(→ Department.id)(→ Employee.id)
11MichaelJohnson2021-06-01Software Engineer800001None
22EmilyWilliams2021-07-01Product Manager9000021
33DavidMartinez2021-08-01Data Analyst7500032
44RachelTaylor2021-09-01UX Designer8500043
55AlexThompson2021-10-01QA Engineer7000054

Department

iddepartmentNamelocation
1EngineeringSan Francisco
2MarketingNew York
3FinanceChicago
4HRLos Angeles
5LegalWashington DC

SalaryHistory

idemployeeIdstartDateendDatesalaryAmount
(→ Employee.id)
112021-06-012022-06-0180000
222021-07-012022-07-0190000
332021-08-012022-08-0175000
442021-09-012022-09-0185000
552021-10-012022-10-0170000