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)

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;

Step by Step Solution

3.38 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Show the effects of the following SQL update operations on the wine cellar datab... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

CS-DB (11).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!