DATABSE (a) Retrieve the names of employees in department 5 who work more than 10 hours per week onthe 'ProductY project.(b) List the names of employees who have a dependent with the same first name as themselves.(c) Find the names of employees that are directly supervised by James Borg'.(d) For each project, list the project name and the minimum hours per week (by allemployees) spent on that project.(e) Retrieve the names of employees who work on every project. (Hint: Division function can beused. You can create a Proj Emp relation with attribute of Pno and SSN, which describe the workon relation between employee and project. Divide it by a Proj(Pno) relation). . Specify relational algebra expressions for the following descriptions on the databaseschema shown in Figure 5.6 using the relational operators discussed in this chapter.Figure 5.6One possible database state for the COMPANY relational database schemaΕMPLOYE ΕMinit LnameSex Salary Super_een Dno123456780 1965-01-00 731 Fondren, Houston, TX M 30000 333445555M 40000 8866555525000 98765432143000 888665555Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 33344555525000 333445555M 25000 087654321FnameSenBdateAddressJohnBSmith5333445555 1965-12-08 638 Voes, Houston, TXZelaya 999887777 1968-01-19 3321 Castle, Spring. TXWallace 987654321 1941-06-20 291 Berry, Bellaire, TXFranklinWongAlicia4JenniferF4RameshKEnglish 453453453 1972-07-31 5631 Rice, Houston, TX987987987 1969-03-29 980 Dalas, Houston, TX888665555 1937-11-10 450 Stone, Houston, TXJoyceAF5AhmadVJabbar4JamesEBorgM 55000 NULLDEPARTMENTDEPT LOCATIONSDnameDnumberMg sanMgr_start dateDnumberDlocationResearch3334455551988-05-221HoustonAdministration49876543211995-01-014StaffordHeadquarters8886655551981-06-195Bellaire5Sugarland5HoustonWORKS ONPROJECTEssnPnoHoursPramePnumberPlocationDnum123456789132.5ProductXBellaire123456789ProductYSugarland27.52666884444340.0ProductzHouston545345345320.0Computerization10Stafford4453453453220.0Reorganization20Houston133344555510.0Newbenefits30Stafford333445555310.03334455551010.0DEPENDENT3334455552010.0EnanDependent nameSexBdateRelationship9998877773030.01986-04-05 Daughter1083-10-25 Son1958-05-03 Spouse1942-02-28 Spouse333445555Alice9998877771010.0333445555TheodoreM9879879871035.0333445555JoyF987987987305.0987054321AbnerM9876543213020.0123456789MichaelM1988-01-04Son9876543212015.0AliceFDaughterSpouse1234567891988-12-3088866555520NULL123456789ElizabethF1967-05-05

For the above given questions the solution is given below:

(a) Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductY' project. (b) List the names of employees who have a dependent with the same first name as themselves. (c) Find the names of employees that are directly supervised by James Borg'. (d) For each project, list the project name and the minimum hours per week (by all employees) spent on that project. (e) Retrieve the names of employees who work on every project. (Hint: Division function can be used. You can create a Proj Emp relation with attribute of Pno and SSN, which describe the work on relation between employee and project. Divide it by a Proj(Pno) relation).