Need some help understanding departments/classes

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 :joy:



Hi @tmike,

It is my long-term intention to map the main elements of the Gibbon database.

I don’t know if the image below can help you.

Gibbon : v26.0.00 ca-fr, PHP v8.2.10, MySQL v8.0.36, Ubuntu 23.10.1

1 Like

Thanks Smarcil, yes that helps.

Main departments = Subject dept
Courses = Subjects we run each week/year
Classes = Assign year groups and staff