Database problems help needed

hi, attached is a file with problems in database programming. 

I need help with it ASAP please.