## University

id | name | location | website | academic_programs
--- | --- | --- | --- | ---
1 | Harvard | Cambridge, Massachusetts | http://www.harvard.edu/ | Business Administration
2 | MIT | Cambridge, Massachusetts | https://mit.edu/ | Computer Science

## College

id | university_id | name | location | website | academic_programs
--- | --- | --- | --- | --- | ---
| (→ University.id) |  |  |  |
101 | 1 | Harvard Business School | Boston, Massachusetts | http://hbs.harvard.edu/ | Business Administration
102 | 2 | MIT Sloan School of Management | Cambridge, Massachusetts | http://mitsloan.mit.edu/ | Management

## Department

id | college_id | department_name | head_of_department | faculty_count
--- | --- | --- | --- | ---
| (→ College.id) |  |  |
301 | 101 | Finance | John Doe | 50
302 | 102 | Marketing | Jane Smith | 60

## Course

id | department_id | course_code | course_title | credits
--- | --- | --- | --- | ---
| (→ Department.id) |  |  |
401 | 301 | FIN101 | Introduction to Finance | 4
402 | 302 | MKT101 | Principles of Marketing | 4

## Student

matriculation_number | first_name | last_name | date_of_birth | email | enrolled_in_course
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Course.id)
701 | Alice | Smith | 1998-05-15 | alice@example.com | None
702 | Bob | Doe | 1999-06-16 | bob@example.com | None

## Enrollment

student_matriculation_number | course_id | grade
--- | --- | ---
(→ Student.matriculation_number) | (→ Course.id) |
701 | 401 | A
702 | 402 | B