## Students

StudentID | FirstName | LastName | Age | GradeLevel
--- | --- | --- | --- | ---
1 | John | Doe | 16 | 10th
2 | Jane | Smith | 17 | 11th
3 | Alice | Brown | 15 | 9th
4 | Bob | White | 18 | 12th
5 | Charlie | Green | 16 | 10th

## Teachers

TeacherID | FirstName | LastName | SubjectTaught
--- | --- | --- | ---
1 | Mrs. | Davis | Mathematics
2 | Mr. | Martin | Physics
3 | Ms. | Hall | Biology
4 | Dr. | Garcia | English Literature
5 | Prof. | Lee | History

## Clubs

ClubID | Name | Description | AdvisorID
--- | --- | --- | ---
|  |  | (→ Teachers.TeacherID)
1 | Math Club | A club for math enthusiasts. | 1
2 | Physics Club | Explore the wonders of physics. | 2
3 | Book Club | Discuss books and share ideas. | 3
4 | Environmental Club | Promote environmental awareness. | 4
5 | Chess Club | Improve strategic thinking through chess. | 5

## LeadershipPrograms

ProgramID | Name | Description | CoordinatorID
--- | --- | --- | ---
|  |  | (→ Teachers.TeacherID)
1 | Peer Mentoring | Help incoming students adjust to high school. | 1
2 | School Newspaper | Write articles and manage production. | 2
3 | Robotics Team | Design and build robots. | 3
4 | Debate Team | Enhance public speaking skills. | 4
5 | Art Club | Express creativity through various art forms. | 5

## ParticipatesIn

ParticipantID | ClubID | ProgramID | NumOfParticipants
--- | --- | --- | ---
(→ Students.StudentID) | (→ Clubs.ClubID) | (→ LeadershipPrograms.ProgramID) |
1 | 1 | None | 30
2 | 2 | 1 | 25
3 | 3 | None | 20
4 | 4 | 2 | 15
5 | 5 | None | 10

## Grades

GradeID | CourseID | StudentID | Grade
--- | --- | --- | ---
| (→ Teachers.TeacherID) | (→ Students.StudentID) |
1 | 1 | 1 | A
2 | 2 | 2 | B+
3 | 3 | 3 | A-
4 | 4 | 4 | B
5 | 5 | 5 | A