Question

Show the effects of the following SQL update operations on the wine cellar database of fig:
a. INSERT INTO CELLAR(BIN#, WINE, PRODUCER, YEAR, BOTTLES, READY) VALUES(80, ‘Syrah’, ‘Meridian’, 1998, 12, 2003);
b. DELETE FROM CELLAR WHERE READY > 2004;
c. UPDATE CELLAR SET BOTTLES = 5 WHERE BIN# = 50;
d. UPDATE CELLAR SET BOTTLES = BOTTLES + 2 WHERE BIN# = 50;


$1.99
Sales0
Views236
Comments0
  • CreatedNovember 03, 2009
  • Files Included
Post your question
5000