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.
- 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.