Students

idfirst_namelast_name
1JohnDoe
2JaneSmith
3MichaelBrown
4EmilyWhite
5WilliamBlack

Classes

class_idcourse_titleinstructor
1Introduction to Computer ScienceDr. Johnson
2Calculus IProf. Williams
3English LiteratureMs. Thompson
4ChemistryDr. Brown
5PhysicsProf. White

Date

date_idyearmonthday
12021915
220211030
32021117
420211218
5202216

Time

time_idhourminutesecond
1900
21000
31100
41200
51300

Enrollment

enrollment_idstudent_idclass_id
(→ Students.id)(→ Classes.class_id)
111
222
333
444
555

Assignments

assignment_iddue_datedue_timedescription
(→ Date.date_id)(→ Time.time_id)
111First project submission
222Final exam preparation
333Group presentation
444Term paper
555Book report