I am creating an intranet for a particular school and I have some questions, how can I design the database in such a way that a teacher can place a note in a subject, it is stored and then a logged student can see that note ?. This is what I have from my database, I attach the photo
Any advice or I'm on track? I have a mess with foreign codes.