Question: Exercise 3 (Relational Algebra) (22 points] O Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated
![Exercise 3 (Relational Algebra) (22 points] O Consider the following relations.](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f51b0d6a9bf_27666f51b0cce84e.jpg)
Exercise 3 (Relational Algebra) (22 points] O Consider the following relations. The primary keys are underlined. All attributes are of type string if not indicated otherwise. [Hint: Use multi-step / multi-line queries to ease the formulation of queries. Use the rename operator p to give intermediate query results a name.] Equipment (equipment_ID, equipment_name, address) Part (part_ID, part_name, condition) The values for condition column are new or used. Catalog (equipment_ID, part_ID, cost: integer) 1. [6 points] Find the names of the most expensive parts of the equipment named Honda'. 2. [4 points) Find the names of the parts installed on at least two different equipments. 3. [4 points] Find the ids of equipments which installed every new part or installed every used part. 4. [4 points] Find pairs of equipment ids such that the equipment with the first equipment_ID costs more for the same part than the equipment with the second equipment_ID. 5. [4 points] Find the names of equipments which installed only new parts
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
