## City

id | name | population
--- | --- | ---
1 | New York | 8398748
2 | Los Angeles | 3960215
3 | Chicago | 2697391
4 | Houston | 2326146
5 | Phoenix | 1681115

## State

id | full_name
--- | ---
1 | New York
2 | California
3 | Illinois
4 | Texas
5 | Arizona

## Campus

id | campus_name | city_id | state_id
--- | --- | --- | ---
|  | (→ City.id) | (→ State.id)
1 | New York University | 1 | 1
2 | University of California Los Angeles | 2 | 2
3 | University of Chicago | 3 | 3
4 | University of Houston | 4 | 4
5 | Arizona State University | 5 | 5

## Teacher

id | firstName | lastName | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Michael | Brown | michael.brown@example.com
4 | Alice | Johnson | alice.johnson@example.com
5 | David | Wilson | david.wilson@example.com

## teachesAt

teacherId | campusId | startDate | endDate
--- | --- | --- | ---
(→ Teacher.id) | (→ Campus.id) |  |
1 | 1 | 2021-01-01 | 2021-12-31
2 | 2 | 2021-01-01 | 2021-12-31
3 | 3 | 2021-01-01 | 2021-12-31
4 | 4 | 2021-01-01 | 2021-12-31
5 | 5 | 2021-01-01 | 2021-12-31

## Student

id | firstName | lastName | email
--- | --- | --- | ---
1 | Emily | Davis | emily.davis@example.com
2 | Alexander | Martinez | alexander.martinez@example.com
3 | Olivia | Garcia | olivia.garcia@example.com
4 | William | Anderson | william.anderson@example.com
5 | Isabelle | Jackson | isabelle.jackson@example.com

## enrolledIn

studentId | campusId | enrollmentStartDate
--- | --- | ---
(→ Student.id) | (→ Campus.id) |
1 | 1 | 2021-01-01
2 | 2 | 2021-01-01
3 | 3 | 2021-01-01
4 | 4 | 2021-01-01
5 | 5 | 2021-01-01