id | name |
---|---|
1 | Harvard University |
2 | Stanford University |
3 | Massachusetts Institute of Technology |
4 | California Institute of Technology |
5 | Yale University |
id | collegeName | universityId |
---|---|---|
(→ University.id) | ||
1 | John F. Kennedy School of Government | 1 |
2 | School of Engineering and Applied Sciences | 1 |
3 | Graduate School of Arts and Sciences | 1 |
4 | Divinity School | 1 |
5 | School of Architecture | 1 |
programId | programName | collegeId |
---|---|---|
(→ College.id) | ||
1 | Business Administration | 1 |
2 | Computer Science | 2 |
3 | Mathematics | 3 |
4 | Physics | 4 |
5 | Philosophy | 5 |
courseId | title | academicProgramId |
---|---|---|
(→ AcademicProgram.programId) | ||
1 | Introduction to Business Management | 1 |
2 | Advanced Calculus | 3 |
3 | General Relativity | 4 |
4 | Logic and Argumentation | 5 |
5 | Ancient Greek Philosophy | 6 |
studentId | firstName | lastName | enrolledCourseId |
---|---|---|---|
(→ Course.courseId) | |||
1 | Jane | Doe | 1 |
2 | John | Smith | 2 |
3 | Alice | Brown | 3 |
4 | Michael | White | 4 |
5 | Emma | Green | 5 |
enrollmentId | studentId | courseId | grade |
---|---|---|---|
(→ Student.studentId) | (→ Course.courseId) | ||
1 | 1 | 1 | A |
2 | 2 | 2 | B+ |
3 | 3 | 3 | A |
4 | 4 | 4 | A- |
5 | 5 | 5 | B |