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 |