[ANSWER HAS TO BE IN RELATIONAL ALGEBRA NOT SQL]

This task asks us to write the relational schema, so there is no real data in this table. This is not asking us to write the SQL, it's relation schema.

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. 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