| id | name |
|---|---|
| 1 | MIT |
| 2 | Stanford |
| 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 |
| 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 |