Students

idfirstNamelastNamedateOfBirth
1JohnDoe2008-09-15
2JaneSmith2007-03-20
3MichaelJohnson2006-11-12
4EmilyWilliams2005-06-01
5DavidBrown2004-02-15

Classes

classIDclassNameteacherName
1MathMr. Thompson
2EnglishMs. Johnson
3HistoryMr. White
4ArtMs. Green
5Physical EducationCoach Black

Enrollments

enrollmentIdstudentIdclassId
(→ Students.id)(→ Classes.classId)
111
222
333
444
555

MilestoneRecords

recordIdstudentIdphysicalMilestonescognitiveMilestoneschildAgeotherDetails
(→ Students.id)
11Walking and runningCounting to 108No additional details
22Riding a bikeReading simple sentences9No additional details
33Climbing stairsRecognizing colors7No additional details
44SwimmingUnderstanding basic concepts10No additional details
55Playing sportsWriting short stories11No additional details

Attendance

attendanceIdstudentIdclassIddateAttendedisPresent
(→ Students.id)(→ Classes.classId)
1112022-09-011
2222022-09-020
3332022-09-031
4442022-09-041
5552022-09-050

DisciplineLogs

logIdstudentIdincidentDatereasonForDisciplinedisciplinaryActionresolutionDate
(→ Students.id)
112022-09-06Talking during classDetention2022-09-08
222022-09-07Cheating on a testSuspension2022-09-10
332022-09-08Bullying another studentApology letter2022-09-10
442022-09-09Damaging school propertyCommunity service2022-09-15
552022-09-10Late assignment submissionExtra credit assignment2022-09-15