Question: QUESTION 12 1. Given the following schema where primary keys are underlined and foreign keys are marked with #, express in Relational Algebra the queries

QUESTION 12 1. Given the following schema where primary keys are

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 Title) Project (projectID, projectName, sponsor, start Year, endYear) WorkedOn (#employeeNo, #projectID, year, month, noHours) a) List the names of employees whose job Title is "database designer". [1 mark] b) List the details of the projects, which are sponsored by "Petrofac". [1 mark] c) List the names of the projects on which the employee number 100 is working. [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!

Calculate the Market Debt/EBITDA ratio given the following fact pattern. Please enter your answer as a multiple with one decimal (for example, 4.0x) Assume no cash Prior-year EBITDA is $50m but is...

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

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 Given the following relational schema where primary keys are underlined and foreign keys are marked with #: COUNTRY (countryId, countryName) TEAM (teamId, teamName, #countryId) PLAYER...

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

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

The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title)...

3.1) List the deptnum and total number of academics for CS departments, in alphabetical order of deptname. CS departments are departments whose deptname contains the phrase "Computer ... Science" or...

QUESTION 5 Answer all parts Consider the following relational schema for a HR database: REGIONS(RegionID, RegionName) COUNTRIES(CountryID, CountryName, RegionID) LOCATIONS(LocationID, Address, City,...

The relational schema for the Academics database is as follows: DEPARTMENT( deptnum, descrip, instname, deptname, state, postcode) ACADEMIC( acnum , deptnum*, famname, givename, initials, title)...

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

What are the advantages of flextime from an employees perspective? From managements perspective?

Explain the differing financial management needs of a small business during the startup, growth, mature, and exit phases.

Which type of insurance utilizes a separate account for an insured's cash value? A endowment B universol life C single - pay whole life variable life insurance

The W - 2 income of Sandra a single taxpayer was 9 0 , 7 6 2 determine Sandra's tax liability use the appropriate tax tables

4. What will the team agreement contain?

Did team members feel like they had autonomy and ownership of the project?

What were the issues and solutions proposed by each team?