| id | firstName | lastName | dateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 2008-09-15 |
| 2 | Jane | Smith | 2007-03-20 |
| 3 | Michael | Johnson | 2006-11-12 |
| 4 | Emily | Williams | 2005-06-01 |
| 5 | David | Brown | 2004-02-15 |
| classID | className | teacherName |
|---|---|---|
| 1 | Math | Mr. Thompson |
| 2 | English | Ms. Johnson |
| 3 | History | Mr. White |
| 4 | Art | Ms. Green |
| 5 | Physical Education | Coach Black |
| enrollmentId | studentId | classId |
|---|---|---|
| (→ Students.id) | (→ Classes.classId) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |
| recordId | studentId | physicalMilestones | cognitiveMilestones | childAge | otherDetails |
|---|---|---|---|---|---|
| (→ Students.id) | |||||
| 1 | 1 | Walking and running | Counting to 10 | 8 | No additional details |
| 2 | 2 | Riding a bike | Reading simple sentences | 9 | No additional details |
| 3 | 3 | Climbing stairs | Recognizing colors | 7 | No additional details |
| 4 | 4 | Swimming | Understanding basic concepts | 10 | No additional details |
| 5 | 5 | Playing sports | Writing short stories | 11 | No additional details |
| attendanceId | studentId | classId | dateAttended | isPresent |
|---|---|---|---|---|
| (→ Students.id) | (→ Classes.classId) | |||
| 1 | 1 | 1 | 2022-09-01 | 1 |
| 2 | 2 | 2 | 2022-09-02 | 0 |
| 3 | 3 | 3 | 2022-09-03 | 1 |
| 4 | 4 | 4 | 2022-09-04 | 1 |
| 5 | 5 | 5 | 2022-09-05 | 0 |
| logId | studentId | incidentDate | reasonForDiscipline | disciplinaryAction | resolutionDate |
|---|---|---|---|---|---|
| (→ Students.id) | |||||
| 1 | 1 | 2022-09-06 | Talking during class | Detention | 2022-09-08 |
| 2 | 2 | 2022-09-07 | Cheating on a test | Suspension | 2022-09-10 |
| 3 | 3 | 2022-09-08 | Bullying another student | Apology letter | 2022-09-10 |
| 4 | 4 | 2022-09-09 | Damaging school property | Community service | 2022-09-15 |
| 5 | 5 | 2022-09-10 | Late assignment submission | Extra credit assignment | 2022-09-15 |