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.