Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Use relational algebra operations to answer the questions pertaining to the illustrated database. 1.Company Database .In class, we have discussed the following Relational Data Model

Use relational algebra operations to answer the questions pertaining to the illustrated database.image text in transcribed

1.Company Database .In class, we have discussed the following Relational Data Model in detail and have used it to praetice on Relational Algebra queries employee nume minit Iname SSN bdae add8xslary superSSN DNO deparlment dname ldnumbeT rSSN mgrStartDate department loc dnumber dlocation project pnber poidrium works on ESSN dependent hours primary kay foreign k SSN feig key ESSNdap-name| sex bdate relationship Formulate the following queries in Relational Algehru on the Company Relational Duta Model: . Find fname and Iname of employees in the 'Research' department that have a 'daughter 2. lind first and last nanes ofenployes who have mure than 5 female depeadents 3. Find first &last nanes of employees who work the longest time -most number of hours) on the ProductX" project 4. Find first &last names of employees in the Research department who work least mumher of total hours 5. Find the name of projects that are warked on by only female employees. 6. lid the Iprujocts tha! arelled by the "Resarch" dpartncal and that are worked ua by ualy lele eiplvys in the "Rescarch' dpartumeat (Le tbe project must be controlled by the Reacarch' department and every employee that works on the projeet must be a female employee in the 'Research" department) or each department list he The output relation has the following format 7. e avem e sa an Mid to e male emp ovees, he avernee salar paid to the emale emp nyees he num er o female emp o ees ad e nam erat male emp oyees in the department dname is kev n relation departmen ena men na Dname Sex AvgSal NumberEnps 8. lid the xi ufte prujcl that is wurked on by he msl auboepluys. 9. Find the name of departments) in which all (every single one) employees in the department have a (at least one) dependent 0.Find the name of projscts that is not worked on by any employee in the department that controls the project

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions