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

Given the following two tables where primary keys are underlined and

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, endYear) WorkedOn (#employeeNo, #projectID, year, month, noHours) a) Express the following queries in Relational Algebra: (1) List names and numbers of employees whose job is entitled "System Analyst". [1 mark] (ii) List all ids of projects that are started in 2015 and sponsored by "Orpic". [1 mark] b) Write the following SQL query in relational algebra:[1 mark] SELECT e.empName, p. projectName FROM Employee e, WorkedOn wo, Project p WHERE e. employeeNo = wo. employeeNo AND P. projectID = wo. projectID

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!

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,...

QUESTION 14 The table below represents the details of jobs along with details of instructors and clients: jobID pickupDate Time driver dFName dLName clienti cFName CL Name Address 1001 1456 Jane Watt...

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,...

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...

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

What is the value in year 10 of a $1,000 cash flow made in year 3 if interest rates are 9 percent?

Water flows steadily through a 10 cm-diameter pipe with a mass flow rate of 1 kg/s. The flow enters the pipe at 200 kPa, 30oC and is gradually heated until it leaves the pipe at 300oC without any...

involves the basic cross - tabulation within various subgroups of the sample. spurious analysis elaboration analysis marginal tabulation index analysis

The budget director for Franklin Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred...

LAST WORD What is the purpose of charging different groups of customers different prices? Supplement the three broad examples in the Last Word with two additional examples of your own. Hint: Think of...

KEY QUESTION The income elasticities of demand for movies, dental services, and clothing have been estimated to be 3.4, 1, and .5, respectively. Interpret these coefficients. What does it mean if an...

ADVANCED ANALYSIS Let MU A z 10 x and MU B z 21 2 y , where z is marginal utility per dollar measured in utils, x is the amount spent on product A, and y is the amount spent on product B....