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 |