Students

idfirstNamelastNamebirthDateenrollmentDate
1JohnDoe1990-06-232018-09-01
2JaneSmith1992-07-152017-01-10
3MichaelBrown1994-08-182019-02-15
4EmilyWhite1996-09-202020-05-01
5WilliamBlack1998-10-222016-08-01

Programs

programIdnamedeadlineMonthdeadlineYear
(→ Deadlines.month)(→ Deadlines.year)
1Computer Science102023
2Mechanical Engineering92024
3Civil Engineering82023
4Electrical Engineering112024
5Biomedical Engineering52023

Deadlines

monthyear
102023
92024
82023
112024
52023

CourseEnrollments

courseIdstudentIdsemestergrade
(→ Courses.id)(→ Students.id)
11FallA
22SpringB+
33SummerA-
44FallB
55WinterA

Courses

idtitlecreditHoursdepartment
1Introduction to Computer Science4CS
2Calculus I3Math
3Physics I3Physics
4English Composition3Literature
5World History3History

Instructors

instructorIdfirstNamelastNameemail
1Dr.Adamsadamsa@example.com
2Prof.Bakerbakera@example.com
3Assoc. Prof.Clarkclarka@example.com
4Asst. Prof.Davisdavisa@example.com
5Asst. Prof.Evansevanse@example.com