Before I ask for your help, I want to make it clear that I know the story. Student comes to forum and posts his assignment expecting others to do it for him. I am a student and this is an assignment, but I tried my best to understand the case and I cannot grasp much more than what I have here:

Case information:
Incomplete ERD: