_{Please answer the following:}

By Looking at the Diagram below, do the Table creation part, Database part then do the requirements: Department Supervisor has DID SID Requirements: 1) Count how many Employees in department Accounting (hint: you will use only table "works_In" which is resulted from many-many relationship between department and employee) 2) Add a new column to table "Project" and name it "Sponsor", you can fill the data of sponsor with either Ford, Xcite or Talabat. 3) Find how many projects were sponsored by Ford. 4) Find the average Salary of all Employees. 5) Find the Maximum Salary among all employees. (Max is one of the functions mentioned in FallLab 22 slides) Dname SName OfficeLoc Has Employee Project EID PID Assign PName EName Salary EDIT: LOC PDes DataBase: 1) Create all the tables using SQL (Codes). 2) Before performing any Command, make sure that you have at least 2 employees in each department. Scroll down for requirements