PLZ help with the following: Make a discount of 10% for all paintings. Write the SQL command to save all the changes made to the table. Remove a gallery number ‘5’ from the GALLERY table. Is deleting a GALLERY row creates sql file CREATE TABLE GALLERY ( GAL_NUM char(4), GAL_OWNER varchar(35), GAL_AREACODE char(3), GAL_PHONE char(8), GAL_RATE number ); INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37); INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 ); INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67); INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER ( PTR_NUM char(4), PTR_LASTNAME varchar(15) NOT NULL, PTR_FIRSTNAME varchar(15) NOT NULL, PTR_AREACODE char(3), PTR_PHONE char(8) ); INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567'); INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112'); INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456'); /* -- */ CREATE TABLE PAINTING ( PTNG_NUM char(4), PTNG_TITLE varchar(35), PTNG_PRICE number, PTR_NUM char(4), GAL_NUM char(4) ); INSERT INTO PAINTING VALUES('1338','Dawn Thunder',245.5,'123','5'); INSERT INTO PAINTING VALUES('1339','A Faded Rose',6723,'123','1'); INSERT INTO PAINTING VALUES('1340','The Founders',567.99,'126','6'); INSERT INTO PAINTING VALUES('1341','Hasty Pudding Exit',145.5,'123',''); INSERT INTO PAINTING VALUES('1342','Plastic Paradise',8328.99,'126','6'); INSERT INTO PAINTING VALUES('1343','Roamin''',785,'127','6'); INSERT INTO PAINTING VALUES('1344','Wild Waters',999,'127','5'); INSERT INTO PAINTING VALUES('1345','Stuff ''n Such ''n Some',9800,'123','5');

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

PLZ help with the following:

  1. Make a discount of 10% for all paintings.

  2. Write the SQL command to save all the changes made to the table.

  3. Remove a gallery number ‘5’ from the GALLERY table. Is deleting a GALLERY row creates

sql file

CREATE TABLE GALLERY (
GAL_NUM char(4),
GAL_OWNER varchar(35),
GAL_AREACODE char(3),
GAL_PHONE char(8),
GAL_RATE number
);
INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);
INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );
INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);
INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30);

/* -- */

CREATE TABLE PAINTER (
PTR_NUM char(4),
PTR_LASTNAME varchar(15) NOT NULL,
PTR_FIRSTNAME varchar(15) NOT NULL,
PTR_AREACODE char(3),
PTR_PHONE char(8)
);
INSERT INTO PAINTER VALUES('123','Ross','Georgette','901','885-4567');
INSERT INTO PAINTER VALUES('126','Itero','Julio','901','346-1112');
INSERT INTO PAINTER VALUES('127','Geoff','George','615','221-4456');

/* -- */

CREATE TABLE PAINTING (
PTNG_NUM char(4),
PTNG_TITLE varchar(35),
PTNG_PRICE number,
PTR_NUM char(4),
GAL_NUM char(4)
);
INSERT INTO PAINTING VALUES('1338','Dawn Thunder',245.5,'123','5');
INSERT INTO PAINTING VALUES('1339','A Faded Rose',6723,'123','1');
INSERT INTO PAINTING VALUES('1340','The Founders',567.99,'126','6');
INSERT INTO PAINTING VALUES('1341','Hasty Pudding Exit',145.5,'123','');
INSERT INTO PAINTING VALUES('1342','Plastic Paradise',8328.99,'126','6');
INSERT INTO PAINTING VALUES('1343','Roamin''',785,'127','6');
INSERT INTO PAINTING VALUES('1344','Wild Waters',999,'127','5');
INSERT INTO PAINTING VALUES('1345','Stuff ''n Such ''n Some',9800,'123','5');

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education