## Students

id | firstName | lastName | birthDate | enrollmentDate
--- | --- | --- | --- | ---
1 | John | Doe | 1990-06-23 | 2018-09-01
2 | Jane | Smith | 1992-07-15 | 2017-01-10
3 | Michael | Brown | 1994-08-18 | 2019-02-15
4 | Emily | White | 1996-09-20 | 2020-05-01
5 | William | Black | 1998-10-22 | 2016-08-01

## Programs

programId | name | deadlineMonth | deadlineYear
--- | --- | --- | ---
|  | (→ Deadlines.month) | (→ Deadlines.year)
1 | Computer Science | 10 | 2023
2 | Mechanical Engineering | 9 | 2024
3 | Civil Engineering | 8 | 2023
4 | Electrical Engineering | 11 | 2024
5 | Biomedical Engineering | 5 | 2023

## Deadlines

month | year
--- | ---
10 | 2023
9 | 2024
8 | 2023
11 | 2024
5 | 2023

## CourseEnrollments

courseId | studentId | semester | grade
--- | --- | --- | ---
(→ Courses.id) | (→ Students.id) |  |
1 | 1 | Fall | A
2 | 2 | Spring | B+
3 | 3 | Summer | A-
4 | 4 | Fall | B
5 | 5 | Winter | A

## Courses

id | title | creditHours | department
--- | --- | --- | ---
1 | Introduction to Computer Science | 4 | CS
2 | Calculus I | 3 | Math
3 | Physics I | 3 | Physics
4 | English Composition | 3 | Literature
5 | World History | 3 | History

## Instructors

instructorId | firstName | lastName | email
--- | --- | --- | ---
1 | Dr. | Adams | adamsa@example.com
2 | Prof. | Baker | bakera@example.com
3 | Assoc. Prof. | Clark | clarka@example.com
4 | Asst. Prof. | Davis | davisa@example.com
5 | Asst. Prof. | Evans | evanse@example.com