Students

StudentIDFirstNameLastNameBirthDateAddress
1JohnDoe2001-07-09123 Main St
2JaneSmith1998-10-14456 Elm St

Teachers

TeacherIDFirstNameLastNameHireDate
1AliceWonderland2015-05-20
2BobDisney2018-06-25

Courses

CourseIDTitleDescriptionTeacherID
(→ Teachers.TeacherID)
1Introduction to MathematicsThis course covers basic mathematical concepts.1
2Advanced ChemistryA comprehensive look at chemical reactions and processes.2

ParticipatesInCourse

StudentIDCourseIDSemesterGrade
(→ Students.StudentID)(→ Courses.CourseID)
11Fall 2022A
22Spring 2023B+

Extracurriculars

ActivityIDClubOrProgramNumberOfParticipantsStartDateEndDate
1Math Club302022-09-012023-05-31
2Math Club452022-09-012023-05-31
3Leadership Program302022-09-012023-05-31
4Leadership Program202022-09-012023-05-31