| 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 |