University

idname
1Harvard University
2Stanford University
3Massachusetts Institute of Technology
4California Institute of Technology
5Yale University

College

idcollegeNameuniversityId
(→ University.id)
1John F. Kennedy School of Government1
2School of Engineering and Applied Sciences1
3Graduate School of Arts and Sciences1
4Divinity School1
5School of Architecture1

AcademicProgram

programIdprogramNamecollegeId
(→ College.id)
1Business Administration1
2Computer Science2
3Mathematics3
4Physics4
5Philosophy5

Course

courseIdtitleacademicProgramId
(→ AcademicProgram.programId)
1Introduction to Business Management1
2Advanced Calculus3
3General Relativity4
4Logic and Argumentation5
5Ancient Greek Philosophy6

Student

studentIdfirstNamelastNameenrolledCourseId
(→ Course.courseId)
1JaneDoe1
2JohnSmith2
3AliceBrown3
4MichaelWhite4
5EmmaGreen5

Enrollment

enrollmentIdstudentIdcourseIdgrade
(→ Student.studentId)(→ Course.courseId)
111A
222B+
333A
444A-
555B