## HigherEducationInstitutionType

id | institutionType
--- | ---
1 | University
2 | College

## AcademicProgram

id | programName
--- | ---
1 | Business Administration
2 | Computer Science

## Student

studentID | firstName | lastName | email | phoneNumber | higherEducationInstitutionId | academicProgramId
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ HigherEducationInstitutionType.id) | (→ AcademicProgram.id)
1 | John | Doe | john@example.com | 1234567890 | 1 | 1
2 | Jane | Smith | jane@example.com | 0987654321 | 1 | 2
3 | Mike | Brown | mike@example.com | 1112223333 | 2 | 1
4 | Alice | White | alice@example.com | 4445556666 | 2 | 2
5 | Tom | Green | tom@example.com | 7778889999 | 1 | None

## Enrollment

enrollmentID | studentId | startDate | endDate
--- | --- | --- | ---
| (→ Student.studentID) |  |
1 | 1 | 2021-09-01 | 2022-05-31
2 | 2 | 2021-09-01 | 2022-05-31
3 | 3 | 2021-09-01 | 2022-05-31
4 | 4 | 2021-09-01 | 2022-05-31
5 | None | 2021-09-01 | 2022-05-31

## Course

courseID | courseTitle | credits | academicProgramId
--- | --- | --- | ---
|  |  | (→ AcademicProgram.id)
1 | Introduction to Business Administration | 3 | 1
2 | Advanced Computer Science | 4 | 2
3 | Fundamentals of Marketing | 3 | 1
4 | Data Structures and Algorithms | 4 | 2
5 | Financial Management | 3 | 1

## AttendenceRecord

attendenceId | studentId | courseId | dateAttended
--- | --- | --- | ---
| (→ Student.studentID) | (→ Course.courseID) |
1 | 1 | 1 | 2021-10-01
2 | 1 | 1 | 2021-10-08
3 | 2 | 2 | 2021-10-01
4 | 2 | 2 | 2021-10-08
5 | None | None | 2021-10-01