City

idnamepopulation
1New York8398748
2Los Angeles3960215
3Chicago2697391
4Houston2326146
5Phoenix1681115

State

idfull_name
1New York
2California
3Illinois
4Texas
5Arizona

Campus

idcampus_namecity_idstate_id
(→ City.id)(→ State.id)
1New York University11
2University of California Los Angeles22
3University of Chicago33
4University of Houston44
5Arizona State University55

Teacher

idfirstNamelastNameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MichaelBrownmichael.brown@example.com
4AliceJohnsonalice.johnson@example.com
5DavidWilsondavid.wilson@example.com

teachesAt

teacherIdcampusIdstartDateendDate
(→ Teacher.id)(→ Campus.id)
112021-01-012021-12-31
222021-01-012021-12-31
332021-01-012021-12-31
442021-01-012021-12-31
552021-01-012021-12-31

Student

idfirstNamelastNameemail
1EmilyDavisemily.davis@example.com
2AlexanderMartinezalexander.martinez@example.com
3OliviaGarciaolivia.garcia@example.com
4WilliamAndersonwilliam.anderson@example.com
5IsabelleJacksonisabelle.jackson@example.com

enrolledIn

studentIdcampusIdenrollmentStartDate
(→ Student.id)(→ Campus.id)
112021-01-01
222021-01-01
332021-01-01
442021-01-01
552021-01-01