Question: By Looking at the Diagram below, do the Table creation part, Database part then do the requirements: Supervisor Department DID SID Requirements: 1) Count how
By Looking at the Diagram below, do the Table creation part, Database part then do the requirements: Supervisor Department 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 Fallab 22 slides) Dame Same Offiloc Employee Project EID PD Asi Name EN Salary Offione PO 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
