Students

StudentIDFirstNameLastNameBirthDateEmail
1JohnDoe1990-01-01john.doe@example.com

Teachers

TeacherIDFirstNameLastNameHireDateEmail
1JaneSmith2010-06-01jane.smith@example.com

Awards

AwardTypeDescription
DiplomaThis award represents completion of a program.

Enrollments

EnrollmentIDCourseIDStudentIDTeacherIDDateEnrolled
(→ Courses.CourseID)(→ Students.StudentID)(→ Teachers.TeacherID)
11122020-08-15
22122020-08-15

Courses

CourseIDTitleCreditHoursCompletionRequirementsAwardProgramUniqueConstraint
1Introduction to Programming3Passing ExamDiplomaNone
2Advanced Mathematics4Project SubmissionDiplomaNone
3Web Development Basics3Passing ExamCertificateNone
4Database Management4Project SubmissionCertificateNone