What is the best way to model this database?

Hi :wave:,
I need to create database for my school project application, but data I need to store in DB are referring to each other so I would really appreciate some help with modeling this DB.

DB Connections:

  • class-teacher connection (talks about who is the headteacher)
  • class-subject connection (talks about which subject is taught, in which class and how many hours per week)
  • subject-class-teacher connection (talks about how many hours a week a given subject is taught by a given teacher in a given class) ( This one is why I can’t figure it out )

Thank you for your help.

Here are some resources

And