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 |