HigherEducationInstitutionType

idinstitutionType
1University
2College

AcademicProgram

idprogramName
1Business Administration
2Computer Science

Student

studentIDfirstNamelastNameemailphoneNumberhigherEducationInstitutionIdacademicProgramId
(→ HigherEducationInstitutionType.id)(→ AcademicProgram.id)
1JohnDoejohn@example.com123456789011
2JaneSmithjane@example.com098765432112
3MikeBrownmike@example.com111222333321
4AliceWhitealice@example.com444555666622
5TomGreentom@example.com77788899991None

Enrollment

enrollmentIDstudentIdstartDateendDate
(→ Student.studentID)
112021-09-012022-05-31
222021-09-012022-05-31
332021-09-012022-05-31
442021-09-012022-05-31
5None2021-09-012022-05-31

Course

courseIDcourseTitlecreditsacademicProgramId
(→ AcademicProgram.id)
1Introduction to Business Administration31
2Advanced Computer Science42
3Fundamentals of Marketing31
4Data Structures and Algorithms42
5Financial Management31

AttendenceRecord

attendenceIdstudentIdcourseIddateAttended
(→ Student.studentID)(→ Course.courseID)
1112021-10-01
2112021-10-08
3222021-10-01
4222021-10-08
5NoneNone2021-10-01