University

idnamelocationwebsiteacademic_programs
1HarvardCambridge, Massachusettshttp://www.harvard.edu/Business Administration
2MITCambridge, Massachusettshttps://mit.edu/Computer Science

College

iduniversity_idnamelocationwebsiteacademic_programs
(→ University.id)
1011Harvard Business SchoolBoston, Massachusettshttp://hbs.harvard.edu/Business Administration
1022MIT Sloan School of ManagementCambridge, Massachusettshttp://mitsloan.mit.edu/Management

Department

idcollege_iddepartment_namehead_of_departmentfaculty_count
(→ College.id)
301101FinanceJohn Doe50
302102MarketingJane Smith60

Course

iddepartment_idcourse_codecourse_titlecredits
(→ Department.id)
401301FIN101Introduction to Finance4
402302MKT101Principles of Marketing4

Student

matriculation_numberfirst_namelast_namedate_of_birthemailenrolled_in_course
(→ Course.id)
701AliceSmith1998-05-15alice@example.comNone
702BobDoe1999-06-16bob@example.comNone

Enrollment

student_matriculation_numbercourse_idgrade
(→ Student.matriculation_number)(→ Course.id)
701401A
702402B