Give Tutorial d formulations for the following updates to the suppliers-parts-projects data-base; (a) Insert a new shipment
Question:
(a) Insert a new shipment with supplier number S1, part number P1, project number J2, quantity 500.
(b) Insert a new supplier S10 into table s (the name and city are Smith and New York, respectively; the status is not yet known).
(c) Delete all blue parts.
(d) Delete all projects for which there are no shipments.
(e) Change the color of all red parts to orange.
(f) Replace all appearances of supplier number S1 by appearances of supplier number S9 instead.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
College Algebra Graphs and Models
ISBN: 978-0321845405
5th edition
Authors: Marvin L. Bittinger, Judith A. Beecher, David J. Ellenbogen, Judith A. Penna
Question Posted: