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