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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!