| 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 |
| 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 |
| month | year |
|---|---|
| 10 | 2023 |
| 9 | 2024 |
| 8 | 2023 |
| 11 | 2024 |
| 5 | 2023 |
| 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 |
| 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 |
| instructorId | firstName | lastName | |
|---|---|---|---|
| 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 |