| StudentID | FirstName | LastName | BirthDate | |
|---|---|---|---|---|
| 1 | John | Doe | 1990-01-01 | john.doe@example.com |
| TeacherID | FirstName | LastName | HireDate | |
|---|---|---|---|---|
| 1 | Jane | Smith | 2010-06-01 | jane.smith@example.com |
| AwardType | Description |
|---|---|
| Diploma | This award represents completion of a program. |
| 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 |
| 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 |