## Students

id | first_name | last_name
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Brown
4 | Emily | White
5 | William | Black

## Classes

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

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

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

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

## Assignments

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