Designing a simple database, what tables and relationships do you need?

Question

MySQL

On the screen there are tables that I think are needed, but something doesn’t fit with me, field types and other subtleties from the bulldozer, I’m interested in the conceptual model. Coursework is defended in a commission consisting of three teachers. It is necessary to solve the problem of distributing finished works among commissions, save the received assessment, an explanatory note in electronic form, a database and program developed by the student, and a presentation of the work. The information is stored in the database until the student graduates from the university.
The problem statement is as follows:
Develop a database that supports course work. The database should store information about the students working on the course work, teachers, the work plan and the implementation of this plan by students. The reports contain information about the leaders and those who miss the deadlines for completing the work.

Answer 1

what a beautiful picture
advice: build queries on your database and see how normalized it is - there should be less JOIN, and at the same time not too much data redundancy, ideally - in general, every table without
redundancy teachers, you can say that in practice in such a problem you can generally not lead to normal forms)))

Answer 2

Actually the question is not clear?
Link the tables with links like https://en.wikipedia.org/wiki/Many-to-many_(data_model) and Foreign Key and go check with the teacher