## Students

StudentID | FirstName | LastName | BirthDate | Email
--- | --- | --- | --- | ---
1 | John | Doe | 1990-01-01 | john.doe@example.com

## Teachers

TeacherID | FirstName | LastName | HireDate | Email
--- | --- | --- | --- | ---
1 | Jane | Smith | 2010-06-01 | jane.smith@example.com

## Awards

AwardType | Description
--- | ---
Diploma | This award represents completion of a program.

## Enrollments

EnrollmentID | CourseID | StudentID | TeacherID | DateEnrolled
--- | --- | --- | --- | ---
| (→ Courses.CourseID) | (→ Students.StudentID) | (→ Teachers.TeacherID) |
1 | 1 | 1 | 2 | 2020-08-15
2 | 2 | 1 | 2 | 2020-08-15

## Courses

CourseID | Title | CreditHours | CompletionRequirements | AwardProgram | UniqueConstraint
--- | --- | --- | --- | --- | ---
1 | Introduction to Programming | 3 | Passing Exam | Diploma | None
2 | Advanced Mathematics | 4 | Project Submission | Diploma | None
3 | Web Development Basics | 3 | Passing Exam | Certificate | None
4 | Database Management | 4 | Project Submission | Certificate | None