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