Students

studentIDfirstNamelastName
1JohnDoe
2JaneSmith
3MichaelBrown
4EmilyWhite
5DavidGreen

Departments

departmentIDnamehead
1MathematicsDr. Johnson
2PhysicsProf. Williams
3BiologyDr. Martinez
4Computer ScienceDr. Lee
5HistoryProf. Clark

Professors

professorIDfirstNamelastNamedepartmentID
(→ Departments.departmentID)
1Dr.Johnson1
2Prof.Williams2
3Dr.Martinez3
4Dr.Lee4
5Prof.Clark5

Courses

courseIDtitlecreditsprofessorID
(→ Professors.professorID)
1Calculus I41
2General Physics32
3Introduction to Biology33
4Discrete Mathematics34
5World History35

Assignments

assignmentIDtypedescription
1HomeworkWeekly homework assignments
2QuizWeekly quizzes
3ProjectGroup project
4EssayResearch essay
5ExamFinal exam

Enrollments

enrollmentIDstudentIDcourseIDgrade
(→ Students.studentID)(→ Courses.courseID)
111None
221None
332None
442None
553None

Courses_Assignments

coursesAssignmentIDcourseIDassignmentID
(→ Courses.courseID)(→ Assignments.assignmentID)
111
212
323
424
535
613
733
843
953