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 DistributorName, Address, Contact Contact
Cars CID CarName, Color, Price, CarType
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
