Question: Give SQL formulations for the following updates

Give SQL formulations for the following updates to the suppliers parts projects database:
a. Insert a new supplier S10 into table S (the name and city are Smith and New York respectively;
the status is not yet known.
b. Delete all projects for which there are no shipments.
c. Change the color of all red parts to orange.
View Solution:


Sale on SolutionInn
Sales1
Views303
Comments
  • CreatedNovember 03, 2009
  • Files Included
Post your question
5000