StudentID | FirstName | LastName | BirthDate | Address |
---|---|---|---|---|
1 | John | Doe | 2001-07-09 | 123 Main St |
2 | Jane | Smith | 1998-10-14 | 456 Elm St |
TeacherID | FirstName | LastName | HireDate |
---|---|---|---|
1 | Alice | Wonderland | 2015-05-20 |
2 | Bob | Disney | 2018-06-25 |
CourseID | Title | Description | TeacherID |
---|---|---|---|
(→ Teachers.TeacherID) | |||
1 | Introduction to Mathematics | This course covers basic mathematical concepts. | 1 |
2 | Advanced Chemistry | A comprehensive look at chemical reactions and processes. | 2 |
StudentID | CourseID | Semester | Grade |
---|---|---|---|
(→ Students.StudentID) | (→ Courses.CourseID) | ||
1 | 1 | Fall 2022 | A |
2 | 2 | Spring 2023 | B+ |
ActivityID | ClubOrProgram | NumberOfParticipants | StartDate | EndDate |
---|---|---|---|---|
1 | Math Club | 30 | 2022-09-01 | 2023-05-31 |
2 | Math Club | 45 | 2022-09-01 | 2023-05-31 |
3 | Leadership Program | 30 | 2022-09-01 | 2023-05-31 |
4 | Leadership Program | 20 | 2022-09-01 | 2023-05-31 |