Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

More Books

Students also viewed these Databases questions

Question

What factors affect a persons choice of careers?

Answered: 1 week ago

Question

Identify and define the eight channels of nonverbal communication

Answered: 1 week ago

Question

4. What will the team agreement contain?

Answered: 1 week ago

Question

What were the issues and solutions proposed by each team?

Answered: 1 week ago