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: http://i.imgur.com/bHiWRAN.png
Incomplete ERD: http://i.imgur.com/X3tH62m.png