Question

2. Given the following database:

Vehicles(manufacturer,model,color,miles,vin)

Vans(manufacturer,model,passengers,cylinders,ABS,price)

Cars(manufacturer,model,cylinders,ABS,price)

SUVs(manufacturer,model,passengers,cylinders,ABS,price)

write the following queries using relational algebra

(a) Find vin and color of all vehicles with price ≥ 15,000.

(b) List manufacturer, model and price of all the blue VANs with price under 12,000.

(c) Find the model number and price of all vehicles of any type made by ”honda”.

(d) Find those manufacturers that make Cars but not Vans.

Answer 1

Vehicles(manufacturer,model,color,miles,vin)

Vans(manufacturer,model,passengers,cylinders,ABS,price)

Cars(manufacturer,model,cylinders,ABS,price)

SUVs(manufacturer,model,passengers,cylinders,ABS,price)

1. Find vin and color of all vehicles with price ≥ 15,000.

  

2. List manufacturer, model and price of all the blue VANs with price under 12,000.

3. Find the model number and price of all vehicles of any type made by ”honda”.

4.  Find those manufacturers that make Cars but not Vans.