Question: 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

 Write the following queries in Relational Algebra for the database shown

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

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!