| CourseID | Core_Concepts | Advanced_Topics | CourseName | TeachersName |
|---|---|---|---|---|
| 1 | Introduction to Math | Calculus and Probability | Math 101 | Mr. Johnson |
| 2 | English Literature | Poetry and Fiction | Engl 101 | Mrs. Williams |
| 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 |