## Students

studentID | firstName | lastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Brown
4 | Emily | White
5 | David | Green

## Departments

departmentID | name | head
--- | --- | ---
1 | Mathematics | Dr. Johnson
2 | Physics | Prof. Williams
3 | Biology | Dr. Martinez
4 | Computer Science | Dr. Lee
5 | History | Prof. Clark

## Professors

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

## Courses

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

## Assignments

assignmentID | type | description
--- | --- | ---
1 | Homework | Weekly homework assignments
2 | Quiz | Weekly quizzes
3 | Project | Group project
4 | Essay | Research essay
5 | Exam | Final exam

## Enrollments

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

## Courses_Assignments

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