Students

StudentIDFirstNameLastNameAgeGradeLevel
1JohnDoe1610th
2JaneSmith1711th
3AliceBrown159th
4BobWhite1812th
5CharlieGreen1610th

Teachers

TeacherIDFirstNameLastNameSubjectTaught
1Mrs.DavisMathematics
2Mr.MartinPhysics
3Ms.HallBiology
4Dr.GarciaEnglish Literature
5Prof.LeeHistory

Clubs

ClubIDNameDescriptionAdvisorID
(→ Teachers.TeacherID)
1Math ClubA club for math enthusiasts.1
2Physics ClubExplore the wonders of physics.2
3Book ClubDiscuss books and share ideas.3
4Environmental ClubPromote environmental awareness.4
5Chess ClubImprove strategic thinking through chess.5

LeadershipPrograms

ProgramIDNameDescriptionCoordinatorID
(→ Teachers.TeacherID)
1Peer MentoringHelp incoming students adjust to high school.1
2School NewspaperWrite articles and manage production.2
3Robotics TeamDesign and build robots.3
4Debate TeamEnhance public speaking skills.4
5Art ClubExpress creativity through various art forms.5

ParticipatesIn

ParticipantIDClubIDProgramIDNumOfParticipants
(→ Students.StudentID)(→ Clubs.ClubID)(→ LeadershipPrograms.ProgramID)
11None30
22125
33None20
44215
55None10

Grades

GradeIDCourseIDStudentIDGrade
(→ Teachers.TeacherID)(→ Students.StudentID)
111A
222B+
333A-
444B
555A