studentID | firstName | lastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Brown |
4 | Emily | White |
5 | David | Green |
departmentID | name | head |
---|---|---|
1 | Mathematics | Dr. Johnson |
2 | Physics | Prof. Williams |
3 | Biology | Dr. Martinez |
4 | Computer Science | Dr. Lee |
5 | History | Prof. Clark |
professorID | firstName | lastName | departmentID |
---|---|---|---|
(→ Departments.departmentID) | |||
1 | Dr. | Johnson | 1 |
2 | Prof. | Williams | 2 |
3 | Dr. | Martinez | 3 |
4 | Dr. | Lee | 4 |
5 | Prof. | Clark | 5 |
courseID | title | credits | professorID |
---|---|---|---|
(→ Professors.professorID) | |||
1 | Calculus I | 4 | 1 |
2 | General Physics | 3 | 2 |
3 | Introduction to Biology | 3 | 3 |
4 | Discrete Mathematics | 3 | 4 |
5 | World History | 3 | 5 |
assignmentID | type | description |
---|---|---|
1 | Homework | Weekly homework assignments |
2 | Quiz | Weekly quizzes |
3 | Project | Group project |
4 | Essay | Research essay |
5 | Exam | Final exam |
enrollmentID | studentID | courseID | grade |
---|---|---|---|
(→ Students.studentID) | (→ Courses.courseID) | ||
1 | 1 | 1 | None |
2 | 2 | 1 | None |
3 | 3 | 2 | None |
4 | 4 | 2 | None |
5 | 5 | 3 | None |
coursesAssignmentID | courseID | assignmentID |
---|---|---|
(→ Courses.courseID) | (→ Assignments.assignmentID) | |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 3 |
4 | 2 | 4 |
5 | 3 | 5 |
6 | 1 | 3 |
7 | 3 | 3 |
8 | 4 | 3 |
9 | 5 | 3 |