Hi am I right in thinking I can create departments Eng, Math, Sci and then within those departments create classes, which I can then assign teachers and students?
For example, we have a science department - run by Mr Paul who is the only science teacher, for English we have 3 teachers, Computing 2 teachers, so should I set up the departments (Subjects) and then add the different classes and teacher for each class?
Our school goes from EYS (early years) to year 13 for the secondary years I can set up form groups, and I guess do the same for primary, the main difference is primary mainly have the same teacher all day, except for specialist subjects, Art, Drama, PE, Computing and Music.
I am trying to get my head around the best way to set this up, I tried creating a relational diagram to try and visualise the structure but got lost with the amount of tables 
Thanks
Mike
