DATABSE Figure 5.6One possible database state for the COMPANY relational database schema.EMPLOYEEFnameMinitLnameSsnBdateAddressSex SalarySuper_ssnDnoJohnSmith1234567891965-01-09 731 Fondren, Houston, TX M30000 333445555FranklinWong333445555 1955-12-08 638 Voss, Houston, TXM40000 888665555AliciaZelaya999887777 1968-01-19 3321 Castle, Spring, TXF25000 9876543214JenniferSWallace 9876543211941-06-20 291 Berry, Bellaire, TXF43000 8886655554RameshKNarayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M38000 |3334455555JoyceAEnglish453453453 1972-07-31 5631 Rice, Houston, TXF25000 3334455555AhmadVJabbar9879879871969-03-29 980 Dallas, Houston, TXM25000 9876543214JamesEBorg888665555 | 1937-11-10 450 Stone, Houston, TXM55000 NULLDEPARTMENTDEPT_LOCATIONSDnameDnumberMgr_ssnMgr_start_dateDnumberDlocationResearch3334455551988-05-221HoustonAdministration49876543211995-01-014StaffordHeadquarters18886655551981-06-19BellaireSugarlandHoustonWORKS_ONPROJECTEssnPnoHoursPnamePnumberPlocationDnum123456789132.5ProductX1Bellaire12345678927.5ProductY2Sugarland666884444340.0ProductZ3Houston453453453120.0Computerization10Stafford4453453453220.0Reorganization20Houston133344555510.0Newbenefits30Stafford333445555310.03334455551010.0DEPENDENT3334455552010.0EssnDependent_nameSexBdateRelationship9998877773030.0333445555Alice1986-04-05Daughter9998877771010.0333445555Theodore1983-10-25Son9879879871035.0333445555JoyF1958-05-03Spouse987987987305.0987654321Abner1942-02-28Spouse9876543213020.0123456789MichaelM1988-01-04Son9876543212015.0123456789AliceF1988-12-30Daughter88866555520NULL123456789ElizabethF1967-05-05Spouse Specify the following queries on the database in Figure 5.6 in SQL.(a) Retrieve the names of employee in department 4 who work more than 15 hours per week onthe 'Newbenefits' project.(b) Find the names of Franklin Wong's supervisor.(c) For each project, list the project name and the total hours per week (by all employees) spent onthat project.(d) Retrieve the names of all employees who work in the department that has the employee withthe highest salary among all employees.(e) Retrieve the names of all employees whose supervisor's supervisor has '888665555’ for SSN.

•For the first query, we need the names of all the employees in department number 5 who work more…

Specify the following queries on the database in Figure 5.6 in SQL. (a) Retrieve the names of employee in department 4 who work more than 15 hours per week o the 'Newbenefits' project. (b) Find the names of Franklin Wong's supervisor. (c) For each project, list the project name and the total hours per week (by all employees) spent c that project.

Specify the following queries on the database in Figure 5.6 in SQL. (a) Retrieve the names of employee in department 4 who work more than 15 hours per week o the 'Newbenefits' project. (b) Find the names of Franklin Wong's supervisor. (c) For each project, list the project name and the total hours per week (by all employees) spent c that project.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Describe the activities for data conversion and changeover.
What steps are involved in data processing?
Explain how microchip technology, such as CPUs and memory, impacts the performance of data warehousing systems.
What steps are involved in data processing?
Database Administration (SQL SERVER ARCHITECTURE ) What is the definition of “Always on Availability”?
List the properties of NoSQL databases?
Explain the steps that are involved in the conversion and changeover of data.
Explain how databases utilize complex datatypes for data storage and retrieval.
Database logs provide two functions. Who or what are they?
What are the steps that go into storing and retrieving data?
What steps are involved in data processing?
Explanation of Data Hiding in terms of OOP.