| 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 |
| 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 |
| id | college_id | department_name | head_of_department | faculty_count |
|---|---|---|---|---|
| (→ College.id) | ||||
| 301 | 101 | Finance | John Doe | 50 |
| 302 | 102 | Marketing | Jane Smith | 60 |
| id | department_id | course_code | course_title | credits |
|---|---|---|---|---|
| (→ Department.id) | ||||
| 401 | 301 | FIN101 | Introduction to Finance | 4 |
| 402 | 302 | MKT101 | Principles of Marketing | 4 |
| matriculation_number | first_name | last_name | date_of_birth | 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 |
| student_matriculation_number | course_id | grade |
|---|---|---|
| (→ Student.matriculation_number) | (→ Course.id) | |
| 701 | 401 | A |
| 702 | 402 | B |