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.

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

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!