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 |
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 |
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 |
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 |
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 |
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 |