StudentID | FirstName | LastName | DateOfBirth | Address |
---|---|---|---|---|
1 | John | Smith | 1990-08-30 | 123 Main St |
2 | Jane | Doe | 1992-06-07 | 456 Elm St |
GradeID | EnrollmentID | Grade | Comments |
---|---|---|---|
(→ Enrollment.EnrollmentID) | |||
1 | 1 | A+ | Excellent work on projects. |
2 | 1 | A- | Great effort on final exam. |
3 | 2 | B+ | Improved a lot over the semester. |
AttendenceID | EnrollmentID | NumberOfDaysPresent | TotalNumberOfClasses | ExcusedAbsences | UnexcusedAbsences |
---|---|---|---|---|---|
(→ Enrollment.EnrollmentID) | |||||
1 | 1 | 20 | 25 | 2 | 1 |
2 | 2 | 22 | 25 | 1 | 0 |
CourseID | Curriculum_Topics | CourseName | TeachersName |
---|---|---|---|
1 | Introduction to Math | Math 101 | Mr. Johnson |
2 | English Literature | Engl 101 | Mrs. Williams |