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 |