## University

id | name
--- | ---
1 | Harvard University
2 | Stanford University
3 | Massachusetts Institute of Technology
4 | California Institute of Technology
5 | Yale University

## College

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

## AcademicProgram

programId | programName | collegeId
--- | --- | ---
|  | (→ College.id)
1 | Business Administration | 1
2 | Computer Science | 2
3 | Mathematics | 3
4 | Physics | 4
5 | Philosophy | 5

## Course

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

## Student

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

## Enrollment

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