You are working on the new internal web system that requires that you use your expertisesearch from the database to provide adequate feedback to your supervisor. The company hascentralized database which lets you organise and manage all the employee data from a singlepoint. With this finest employee database, the end user can easily track the Projects, Leaves,Attendances, Timesheets, Salaries, Expenses, and more from employee. Keep the log ofemployee lifecycle and examine the improvements in your workforce over the period with thisemployee database management system. Use the Company_XYZ database to write the SQLqueries that solve the questions below. Perform an SQL request to search in the database for full name of each employee whoworks on all the projects controlled by department number 4 together with theirdepended, ordered by the first names. Sex Salary Super_san Dno123456789 1965-01-09 731 Fondren, Houston, TX M 30000 33344550540000 888665055FnameMinitLnameSanBdateAddressJohnBSmithFranklinWong333445055 1955-12-08 638 Voss, Houston, TXM999887777 1968-01-19 3321 Castle, Spring. TXF 20000 987654321ZelayaWallace 987654321Alicia4Jenniter1941-06-20 291 Berry, Bellaire, TX43000 8886600054Ramesh KNarayan 666884444 1962-09-15 975 Fire Oak, Humble, TX MA EnglishVE Borg38000 33344500020000 3334455551969-03-29 980 Dallas, Houston, TX M 23000 987604321888660000 1937-11-10 450 Stone, Houston, TX M 0o000 NULLJoyce453453453 1972-07-31 5631 Rice, Houston, TXFAhmadJabbar9879879874James1DEPT LOCATIONSDEPARTMENTDnumberDnumberDlocationDnameResearchAdministrationMgr_ssnMgr_start_date3334450501988-05-221Houston4.9876543211990-01-01StaffordHeadquarters8886600051981-06-19BellaireSugarlandHoustonWORKS ONEssnPROJECTPno HoursPnamePnumber PlocationDnum12345678932.5ProductXBellaireSugarland12340678927.0ProductY66688444440.0Productz3HoustonStaffordComputerizationReorganizationNewbenefits45340345320.0104453403453220.020Houston333445000210.030Stafford4333445000310.03334450001010.0DEPENDENT3334450002010.0EssnDependent_name SexBdateRelationship9998877773030.0333440005AliceF1986-04-05 Daughter9998877771010.0333440000Theodore1983-10-25Son9879879871035.01958-00-03 SpouseJoyAbner333440000987987987300.09876543211942-02-28Spouse9876543213020.0123456789Michael1988-01-04Son9876543212010.0123456789Alice1988-12-30 DaughterB8866000020NULL123456789Elizabeth1967-05-00Spouse

JOINS in sql: A JOIN clause in sql is used to combine or join rows from two or more tables, that…

Answered: You are working on the new internal web…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

You are working on the new internal web system that requires that you use your expertise
search from the database to provide adequate feedback to your supervisor. The company has
centralized database which lets you organise and manage all the employee data from a single
point. With this finest employee database, the end user can easily track the Projects, Leaves,
Attendances, Timesheets, Salaries, Expenses, and more from employee. Keep the log of
employee lifecycle and examine the improvements in your workforce over the period with this
employee database management system. Use the Company_XYZ database to write the SQL
queries that solve the questions below.

Perform an SQL request to search in the database for full name of each employee who
works on all the projects controlled by department number 4 together with their
depended, ordered by the first names.