Use the Relational Algebra to express the following queries:
(a) Find the makes of all cars manufactured by ?Mercedes/Chrysler?
(b) Find the names and addresses of all dealers who sell Plymouths (i.e., cars with make
'Plymouth'.)
(c) Find the addresses of dealers that sell at least one make of car manufactured by a company
incorporated in Japan.
(d) Find all dealers who don't sell any car manufactured by ?Mercedes/Chrysler?.
Consider the following schema:
Manufacturer(MName,HQAddress,Country)
Car(Make,ModelNum,MName,Kind)
Dealership(DName,DAddress)
Sell(DName,Make,ModelNum)
Solution:
(a) 
(b) 
(c) 
(d) 
You might also like to view...
How do you create a World object?
What will be an ideal response?
How do you access the Word Options dialog box?
A) Click the Office Logo button in the top left corner of the screen. B) Click the question mark button in the top right corner of the screen. C) Click the maximize button in the top right corner of the screen. D) Click the Office Logo button in the top right corner of the screen.
How does the printer PPI affect the print quality (how noticeable the printer dots are) of your printed image?
What will be an ideal response?
The syntax used to declare a StreamWriter variable is ____.
A. {Dim|Private} streamWriterVariableName IO.StreamWriter B. {Dim|Private} streamWriterVariableName As IN.StreamWriter C. {Dim|Private} streamWriterVariableName As IO.StreamWriter D. {Dim|Private} streamWriterVariableName As StreamWriter