id | name | location |
---|---|---|
1 | Harvard Medical School | Boston |
2 | Johns Hopkins University School of Medicine | Baltimore |
3 | Stanford University School of Medicine | Stanford |
4 | University of California - San Francisco School of Medicine | San Francisco |
5 | Yale School of Medicine | New Haven |
id | courseName | duration |
---|---|---|
1 | Anatomy | 2 |
2 | Biology | 2 |
3 | Physiology | 1 |
4 | Pharmacology | 3 |
5 | Pathology | 3 |
id | schoolId | courseId |
---|---|---|
(→ Medical_Schools.id) | (→ Courses.id) | |
1 | 1 | 1 |
2 | 2 | 1 |
3 | 3 | 1 |
4 | 4 | 1 |
5 | 5 | 1 |
6 | 5 | 2 |