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 |