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

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) o 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
