IT Database Question/ERD Help

Please see the attached word document on the questions. Also, included is the project document for reference, ERD image and the ERD summary. This task requires someone with DB expereince/knowledge and can create using ER assistant.