Use the following code to Write the SQL command to change the price code for all Action movies to price code 3. show an updated movie table CREATE TABLE PRICE ( PRICE_CODE NUMBER(2,0) PRIMARY KEY, PRICE_DESCRIPTION VARCHAR2(20) NOT NULL , PRICE_RENTFEE NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) ); CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE RENTAL ( RENT_NUM NUMBER(8,0) PRIMARY KEY, RENT_DATE DATE DEFAULT SYSDATE, MEM_NUM NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1); INSERT INTO PRICE VALUES (2, 'New Release', 3.5, 3); INSERT INTO PRICE VALUES (3, 'Discount', 1.5, 1); INSERT INTO PRICE VALUES (4, 'Weekly Special', 1, .5); MOVIE: INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1); VIDEO: INSERT INTO VIDEO VALUES (34342, '22-JAN-22', 1235); INSERT INTO VIDEO VALUES (34366, '02-MAR-23', 1236); INSERT INTO VIDEO VALUES (34367, '02-MAR-23', 1236); INSERT INTO VIDEO VALUES (34368, '02-MAR-23', 1236); INSERT INTO VIDEO VALUES (34369, '02-MAR-23', 1236); INSERT INTO VIDEO VALUES (44392, '21-OCT-22', 1237); INSERT INTO VIDEO VALUES (44397, '21-OCT-22', 1237); INSERT INTO VIDEO VALUES (54321, '18-JUN-22', 1234); INSERT INTO VIDEO VALUES (54324, '18-JUN-22', 1234); INSERT INTO VIDEO VALUES (54325, '18-JUN-22', 1234); RENTAL: INSERT INTO RENTAL VALUES (1001, '01-MAR-23', 103); INSERT INTO RENTAL VALUES (1002, '01-MAR-23', 105); INSERT INTO RENTAL VALUES (1003, '02-MAR-23', 102); INSERT INTO RENTAL VALUES (1004, '02-MAR-23', 110); INSERT INTO RENTAL VALUES (1006, '02-MAR-23', 107); INSERT INTO RENTAL VALUES (1007, '02-MAR-23', 104); INSERT INTO RENTAL VALUES (1008, '03-MAR-23', 105); INSERT INTO RENTAL VALUES (1009, '03-MAR-23', 111);
Use the following code to Write the SQL command to change the price code for all Action movies to price code 3. show an updated movie table
CREATE TABLE PRICE (
PRICE_CODE NUMBER(2,0) PRIMARY KEY,
PRICE_DESCRIPTION VARCHAR2(20) NOT NULL ,
PRICE_RENTFEE NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0),
PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0)
);
CREATE TABLE MOVIE (
MOVIE_NUM NUMBER(8,0) PRIMARY KEY,
MOVIE_TITLE VARCHAR2(75) NOT NULL,
MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900),
MOVIE_COST NUMBER(5,2),
MOVIE_GENRE VARCHAR2(50),
PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE
);
CREATE TABLE RENTAL (
RENT_NUM NUMBER(8,0) PRIMARY KEY,
RENT_DATE DATE DEFAULT SYSDATE,
MEM_NUM NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP
);
PRICE:
INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);
INSERT INTO PRICE VALUES (2, 'New Release', 3.5, 3);
INSERT INTO PRICE VALUES (3, 'Discount', 1.5, 1);
INSERT INTO PRICE VALUES (4, 'Weekly Special', 1, .5);
MOVIE:
INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2);
INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1);
INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2);
INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2);
INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL);
INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3);
INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);
VIDEO:
INSERT INTO VIDEO VALUES (34342, '22-JAN-22', 1235);
INSERT INTO VIDEO VALUES (34366, '02-MAR-23', 1236);
INSERT INTO VIDEO VALUES (34367, '02-MAR-23', 1236);
INSERT INTO VIDEO VALUES (34368, '02-MAR-23', 1236);
INSERT INTO VIDEO VALUES (34369, '02-MAR-23', 1236);
INSERT INTO VIDEO VALUES (44392, '21-OCT-22', 1237);
INSERT INTO VIDEO VALUES (44397, '21-OCT-22', 1237);
INSERT INTO VIDEO VALUES (54321, '18-JUN-22', 1234);
INSERT INTO VIDEO VALUES (54324, '18-JUN-22', 1234);
INSERT INTO VIDEO VALUES (54325, '18-JUN-22', 1234);
RENTAL:
INSERT INTO RENTAL VALUES (1001, '01-MAR-23', 103);
INSERT INTO RENTAL VALUES (1002, '01-MAR-23', 105);
INSERT INTO RENTAL VALUES (1003, '02-MAR-23', 102);
INSERT INTO RENTAL VALUES (1004, '02-MAR-23', 110);
INSERT INTO RENTAL VALUES (1006, '02-MAR-23', 107);
INSERT INTO RENTAL VALUES (1007, '02-MAR-23', 104);
INSERT INTO RENTAL VALUES (1008, '03-MAR-23', 105);
INSERT INTO RENTAL VALUES (1009, '03-MAR-23', 111);
Step by step
Solved in 3 steps with 1 images
