## University

id | name
--- | ---
1 | MIT
2 | Stanford

## Chemist

id | university_id | firstName | lastName | fieldOfStudy
--- | --- | --- | --- | ---
| (→ University.id) |  |  |
1 | 1 | John | Doe | Organic Chemistry
2 | 1 | Jane | Smith | Inorganic Chemistry
3 | 2 | Alice | Brown | Physical Chemistry
4 | 2 | Bob | White | Analytical Chemistry

## Geoscientist

id | university_id | firstName | lastName | fieldOfStudy
--- | --- | --- | --- | ---
| (→ University.id) |  |  |
1 | 1 | Tom | Jackson | Geology
2 | 1 | Emma | Nelson | Seismology
3 | 2 | Mike | Garcia | Paleontology
4 | 2 | Lisa | Hill | Oceanography