| id | name | population |
|---|---|---|
| 1 | New York | 8398748 |
| 2 | Los Angeles | 3960215 |
| 3 | Chicago | 2697391 |
| 4 | Houston | 2326146 |
| 5 | Phoenix | 1681115 |
| id | full_name |
|---|---|
| 1 | New York |
| 2 | California |
| 3 | Illinois |
| 4 | Texas |
| 5 | Arizona |
| 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 |
| id | firstName | lastName | |
|---|---|---|---|
| 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 |
| 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 |
| id | firstName | lastName | |
|---|---|---|---|
| 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 |
| 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 |