I have an assignment that has a solution, but I want some modifications to it, a

I have an assignment that has a solution, but I want some modifications to it, a

I have an assignment that has a solution, but I want some modifications to it, and I want to make a presentation for it. I will attach the solved file and indicate the modifications I want.
&&&&&&&
1-ER diagram needs to be fixed (the relationships mentioned and diagram must be similar to the picture) and you need to check the table of relationships before the diagram it might be has some mistakes to be corrected.
2- point (E) normalization after must be changed to up 3NF the solved one is 4NF