## Medical_Schools

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

## Courses

id | courseName | duration
--- | --- | ---
1 | Anatomy | 2
2 | Biology | 2
3 | Physiology | 1
4 | Pharmacology | 3
5 | Pathology | 3

## Medical_School_Courses

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