Concept explainers
Answer Problem 13 using SQL.
PROBLEM 13
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
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?
Learn your wayIncludes step-by-step video
Chapter 9 Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Additional Engineering Textbook Solutions
C Programming Language
Introduction to Java Programming and Data Structures, Comprehensive Version (11th Edition)
Database Concepts (7th Edition)
Starting Out with C++ from Control Structures to Objects (8th Edition)
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
Starting Out with C++ from Control Structures to Objects (9th Edition)
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning