Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write the following queries in Relational Algebra for the database shown below. 10/15/1980 3/6/25 4/11/19 Female 3/12/1972 Order No Order Type Cosmetics Dept No Manager

image text in transcribed

Write the following queries in Relational Algebra for the database shown below. 10/15/1980 3/6/25 4/11/19 Female 3/12/1972 Order No Order Type Cosmetics Dept No Manager Department Dept Name Overseas VIP Traditional Order Amount(USD) 14023 134.89 123.45 Grocery Home Order Date 1/23/2019 12/12/2018 11/12/2018 9/14/2018 B/30/2018 9/12/2018 132.9 100.9 Grocery NOTE You can use the symbols if the editor allows it, or you can put the name of the operation if you prefer it, for example: actors john = PROJECTION actor actor id (SELECTION actor.first_name = JOHN (actor)) film_ids_john = PROJECTION film actor film Id (factors_john) TETHA JOIN actor actor id = film actor actor_id (film_actor)) (a) Write a relational Algebra query to retrieve the Order No of all orders where the amount is higher than 135 USD (2 points (b) Write a relational Algebra query to retrieve the names and gender of all employees who work for the 'VIP department (4 points) (c) Write a relational Algebra query to find the names of employees that are NOT directly supervised by 'Ashley: (4 points)

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

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

Recommended Textbook for

Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker

Authors: Michael L. Brodie

1st Edition

1947487167, 978-1947487161

More Books

Students also viewed these Databases questions

Question

Create an example of a policy window as defined by kingdon

Answered: 1 week ago