Give Tutorial d formulations for the following updates to the suppliers-parts-projects data-base;
(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.

  • CreatedJuly 14, 2010
  • Files Included
Post your question