Question
Consider the Car database with the following relation : Distributor(DID, Distributor_Name, Distributor_Address, Distributor_Contact) Cars(CID, Car_Name, Car_Color, Price, Car_Type) Catalogue(DID, CID, Cost, Model) Write the following
Consider the Car database with the following relation :
Distributor(DID, Distributor_Name, Distributor_Address, Distributor_Contact) Cars(CID, Car_Name, Car_Color, Price, Car_Type) Catalogue(DID, CID, Cost, Model)
Write the following queries in relationak algebra : i. Create the table with appropriate constraints ii. Display the IDs of the distributor who distribute all Minivans. iii. Display the IDs of the distributor who distribute some Coupe and some Convertible cars iv. Display the IDs of distributor who distribute only Wagons v. Display the group of DIDs such that the distributor with the first DID cost is high for some cars than the distributor with the second DID
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started