Question: Given the following schema where primary keys are underlined and foreign keys are marked with #, express in Relational Algebra the queries below: Employee (employeeNo,

Given the following schema where primary keys are underlined and foreign keys are marked with #, express in Relational Algebra the queries below: Employee (employeeNo, empName, jobTitle) Project (projectID, projectName, sponsor, startYear, endYear) WorkedOn (#employeeNo, #projectID, year, month, noHours) a) List the Ids and names of projects, which are sponsored by "Petrofac" and finished before 2021. [1 mark] b) List the numbers of employees (employeeNo) who worked on projects in 2020. [1 mark] c) List the name of the projects on which employees spent more than 500 hours. [1 mark]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Allen Moving and Storage prepared the following income statement for 2 0 1 8 : CHECK FIGURE ( 2 ) Break - even sales = $ 4 , 8 3 8 , 4 8 5 Revenues: Local: $ 1 , 4 3 3 , 5 0 0 Intra - province: $ 5 1...

QUESTION 12 Given the following schema where primary keys are underlined and foreign keys are marked with #, express in Relational Algebra the queries below: Employee(employeeNo, empName, jobTitle)...

Urgent: Given the following schema where primary keys are underlined and foreign keys are marked with #, express in Relational Algebra the queries below: Employee(employeeNo, empName, jobTitle)...

QUESTION 12 1. Given the following schema where primary keys are underlined and foreign keys are marked with #, express in Relational Algebra the queries below: Employee (employeeNo, empName, job...

Given the following two tables where primary keys are underlined and foreign keys are marked with #: Employee (employeeNo, empName, jobTitle) Project (projectID, projectName, sponsor, startYear,...

Given the following two tables where primary keys are underlined and foreign keys are marked with #: Employee (employeeNo, empName, job Title) Project (projectID, projectName, sponsor, start Year,...

QUESTION 12 Given the following two tables where primary keys are underlined and foreign keys are marked with #: Employee (employee No, empName, job Title) Project (projectID, projectName, sponsor,...

Given the following relational schema, where primary keys are underlined and foreign keys are marked with #: Employee (employeeID, empFName, empLName, empDateBirth, address, #DepartmentID) Department...

Problem 3.2 (2 points). (these are vectors in Rm). Consider a matrix A E Rmxn and denote by (C,... Cn) its columns Prove the equality of the sets Im(A) = Span(c,..., Cn).

Let w be an exact one-form on R2, and suppose that its integral along the line segment from (0, 0) to (2, 0) is equal to 3. Determine the integral I of w going counterclockwise around the upper...

E9.18 (LO 3) (Non-Monetary Exchange) Montgomery Ltd. purchased an electric wax melter on April 30, 2026, by trading in its old gas model and paying the balance in cash. The following data relate to...

Wages of $9.000 are earned by workers but not paid as of December 31. 2017. b. Depreciation on the company's equipment for 2017 is $10, 840. c. The Office Supplies account had a $400 debit balance on...

1. [From the head of your agency] Ive heard some disturbing rumors about the way you treat our clients. a. Thats ridiculous. b. You cant believe everything you hear. c. Could you please be more...

5. Under what circumstances is introducing yourself to someone you dont know a good idea? When is introducing yourself not such a good idea?

4. [From a legislator or a member of the city council] I want to see all the information we have on the new construction project, and I want it in my office in 1 hour. a. Thats none of your business....