ActivityID | Name |
---|---|
1 | Art |
2 | Math |
3 | Physical Education |
4 | History |
5 | English |
ProgramID | Name | Description | StartDate | EndDate |
---|---|---|---|---|
1 | Art Classes | Learn various art forms like painting, drawing, sculpture etc. | 2023-09-15 | 2023-12-18 |
2 | Math Club | Club to help students improve their math skills. | 2023-09-16 | 2023-12-20 |
3 | Fitness Camp | A physical education program aimed at improving fitness levels. | 2023-09-17 | 2023-12-21 |
4 | Historical Society | Study about different historical periods. | 2023-09-18 | 2023-12-22 |
5 | Book Club | Discuss various books read by members. | 2023-09-19 | 2023-12-23 |
ParticipantId | FirstName | LastName | Age |
---|---|---|---|
1 | John | Doe | 12 |
2 | Jane | Smith | 11 |
3 | Tom | Brown | 13 |
4 | Alice | Green | 12 |
5 | Charlie | Black | 14 |
EnrollmentID | ParticipantID | ProgramID |
---|---|---|
(→ Participants.ParticipantId) | (→ AfterSchoolPrograms.ProgramID) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
AfterSchoolProgramsID | ActivityID |
---|---|
(→ AfterSchoolPrograms.ProgramID) | (→ Activities.ActivityID) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |