| 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 |