Advance Database Help Please

Can someone help, I need all of these questions done on this assignment for Advanced Database Management Class.