Question: Consider the Car database with the following relation: Distributor ( DID , Distributor _ Name, Address, Contact 1 , Contact 2 ) Cars ( CID

Consider the Car database with the following relation:
Distributor (DID, Distributor_Name, Address, Contact1, Contact2)
Cars (CID, Car_Name, Color, Price, Car_Type)
Catalogue (DID, CID, Cost, Model)
Write the following queries in relational algebra:
(i) How many swift car distributors are available in Vellore?
(ii) Display all distributer available in Vellore having red colour car.
(iii) Display the name, address and contact number of the distributors who distribute SUV
or Sedan Cars.
(iv) Display the cost of SUV given by all distributors.

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 Programming Questions!