Chapter 4 Homework

The database diagrams are a little different to the ones I'm used to, hopefully they make sense but I suspect I may need some pointers.