Computer science or c++ 13. Using the commands SELECT, PROJECT, and JOIN, write

Question

Computer science or c++

13. 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 Bolt 2Z Nut V5 1.5 0.5 Manufacturer relation CompanyName PartName Cost Company X Bolt 2Z .03 Company X Nut V5 .01 Company Y Bolt 2X .02 CompanyY Nut V5 CompanyY Bolt 2Z 04 Company 2z .01 Nut V5 .01 a. Which companies make Bolt 2Z? madeby Company X C. Which companies make a part with weight 1 ? along with each part's cost.

Explanation / Answer

Use it.

a). SELECT CompanyName FROM Manufacturer WHERE PartName= 'Bolt 2Z';

b). SELECT PartName, Cost FROM Manufacturer WHERE CompanyName= 'Company X';

c). SELECT Manufacturer.CustomerName
FROM Part INNER JOIN Manufacturer
ON Part.PartName=Manufacturer.PartName WHERE Weight = 1;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.