Question: Write the following queries in Relational Algebra for the database shown below. (Queries in SQL will be graded with a zero) (Queries hardcoding Id's will

 Write the following queries in Relational Algebra for the database shown

below. (Queries in SQL will be graded with a zero) (Queries hardcoding

Write the following queries in Relational Algebra for the database shown below. (Queries in SQL will be graded with a zero) (Queries hardcoding Id's will be graded with a zero) 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 ((actors_john) TETHA JOIN actor.actor_id = film_actor.actor_id (film_actor)) 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 ((actors_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 (4 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 in a department managed by 'Rachel' or 'James'. (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!