| id | name |
|---|---|
| 1 | Harvard University |
| 2 | Stanford University |
| 3 | Massachusetts Institute of Technology |
| 4 | California Institute of Technology |
| 5 | Yale University |
| id | collegeName | universityId |
|---|---|---|
| (→ University.id) | ||
| 1 | John F. Kennedy School of Government | 1 |
| 2 | School of Engineering and Applied Sciences | 1 |
| 3 | Graduate School of Arts and Sciences | 1 |
| 4 | Divinity School | 1 |
| 5 | School of Architecture | 1 |
| programId | programName | collegeId |
|---|---|---|
| (→ College.id) | ||
| 1 | Business Administration | 1 |
| 2 | Computer Science | 2 |
| 3 | Mathematics | 3 |
| 4 | Physics | 4 |
| 5 | Philosophy | 5 |
| courseId | title | academicProgramId |
|---|---|---|
| (→ AcademicProgram.programId) | ||
| 1 | Introduction to Business Management | 1 |
| 2 | Advanced Calculus | 3 |
| 3 | General Relativity | 4 |
| 4 | Logic and Argumentation | 5 |
| 5 | Ancient Greek Philosophy | 6 |
| studentId | firstName | lastName | enrolledCourseId |
|---|---|---|---|
| (→ Course.courseId) | |||
| 1 | Jane | Doe | 1 |
| 2 | John | Smith | 2 |
| 3 | Alice | Brown | 3 |
| 4 | Michael | White | 4 |
| 5 | Emma | Green | 5 |
| enrollmentId | studentId | courseId | grade |
|---|---|---|---|
| (→ Student.studentId) | (→ Course.courseId) | ||
| 1 | 1 | 1 | A |
| 2 | 2 | 2 | B+ |
| 3 | 3 | 3 | A |
| 4 | 4 | 4 | A- |
| 5 | 5 | 5 | B |