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 |