Answer question 1 using SQL.
Question 1
Using the commands SELECT, PROJECT, and JOIN, write a sequence of instructions to answer each of the following questions about parts and their manufacturers in terms of the following database:
Part relation |
|
PartName | Weight |
Bolt 2X | 1 |
Bolt 2Z | 1.5 |
Nut V5 | 0.5 |
Manufacturer relation |
|
|
CompanyName | PartName | Cost |
Company X | Bolt 2Z | .03 |
Company X | Nut V5 | .01 |
Company Y | Bolt 2X | .02 |
Company Y | Nut V5 | .01 |
Company Y | Bolt 2Z | .04 |
Company Z | Nut V5 | .01 |
a. Which companies make Bolt 2Z?
b. Obtain a list of the parts made by Company X along with each part’s cost.
c. Which companies make a part with weight 1?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.