| id | institutionType |
|---|---|
| 1 | University |
| 2 | College |
| id | programName |
|---|---|
| 1 | Business Administration |
| 2 | Computer Science |
| studentID | firstName | lastName | 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 |
| 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 |
| 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 |
| 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 |