Children can have linked teacher, linked parents to view progress
To begin, tables needed are:
Child
Parent
Teacher
Linking (For Parent/Child, is Authorised by a teacher)
Progress report table (add as teacher, viewable by all if authorised)
Calender items
Lesson resources
Class (Contains Year, Teacher Tutor, all children in class (must be same year?) and name of Class (e.g. Year 1 Maths)
Year (Reception/Year 1/2 etc - with IDs of Year)
Homework submissions
Children can have linked teacher, linked parents to view progress
To begin, tables needed are: Child Parent Teacher Linking (For Parent/Child, is Authorised by a teacher) Progress report table (add as teacher, viewable by all if authorised) Calender items Lesson resources Class (Contains Year, Teacher Tutor, all children in class (must be same year?) and name of Class (e.g. Year 1 Maths) Year (Reception/Year 1/2 etc - with IDs of Year) Homework submissions