id | first_name | last_name |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Brown |
4 | Emily | White |
5 | William | Black |
class_id | course_title | instructor |
---|---|---|
1 | Introduction to Computer Science | Dr. Johnson |
2 | Calculus I | Prof. Williams |
3 | English Literature | Ms. Thompson |
4 | Chemistry | Dr. Brown |
5 | Physics | Prof. White |
date_id | year | month | day |
---|---|---|---|
1 | 2021 | 9 | 15 |
2 | 2021 | 10 | 30 |
3 | 2021 | 11 | 7 |
4 | 2021 | 12 | 18 |
5 | 2022 | 1 | 6 |
time_id | hour | minute | second |
---|---|---|---|
1 | 9 | 0 | 0 |
2 | 10 | 0 | 0 |
3 | 11 | 0 | 0 |
4 | 12 | 0 | 0 |
5 | 13 | 0 | 0 |
enrollment_id | student_id | class_id |
---|---|---|
(→ Students.id) | (→ Classes.class_id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
assignment_id | due_date | due_time | description |
---|---|---|---|
(→ Date.date_id) | (→ Time.time_id) | ||
1 | 1 | 1 | First project submission |
2 | 2 | 2 | Final exam preparation |
3 | 3 | 3 | Group presentation |
4 | 4 | 4 | Term paper |
5 | 5 | 5 | Book report |