Question
Using the Company Database to execute following query. Query 1: Retrieve the First and Last name of all the managers who work on the Project
Using the Company Database to execute following query.
Query 1: Retrieve the First and Last name of all the managers who work on the Project located in Houston and controlled by the department they manage. Also list the name of the department they manage.
Query 2: Retrieve the First and Last name of all the managers who work on Project located in Houston and has no dependents.
Query 3: List First Name of all the managers and name of the dependent if they have any. Also list the name of the department they manage.
Query 4: For all the projects in the company. List the following;
Names of the projects in the company.Total number of hours worked on each of these projects by all employees.Total number of employees working on each of these projects,Maximum number of hours worked by any employee on each of these project.
EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super sn Dro DEPARTMENT Dname Dnumber Mg.sn Mag. sat date DEPT LOCATIONS number Dlocation PROJECT Pname Pumber Plocation Dum you ous 20 WORKS ON Essn Pno Hours DEPENDENT Essn Degendent name Sex Bdate Relationship DAT604 April_2018Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started