SQL

Required Keywords:

The DVD_vidrental database contains 6 tables, and you can find the database diagram below. price PRICE_CODE DECIMAL(2,0) PRICE_DESCRIPTION VARCHAR(20) PRICE_RENTFEE DECIMAL(5,2) PRICE_DAILYLATEFEE DECIMAL(5,2) Indexes movie MOVIE_NUM DECIMAL(8,0) MOVIE_TITLE VARCHAR(75) MOVIE_YEAR DECIMAL(4,0) MOVIE_COST DECIMAL(5,2) MOVIE_GENRE VARCHAR(50) PRICE_CODE DECIMAL(2,0) Indexes video VID_NUM DECIMAL(8,0) - VID_INDATE DATE MOVIE_NUM DECIMAL(8,0) Indexes Video Rental Database (Videorental_db.sql) membership MEM_NUM DECIMAL(8,0) MEM_FNAME VARCHAR(30) MEM_LNAME VARCHAR(30) MEM_STREET VARCHAR(120) MEM_CITY VARCHAR(50) MEM_STATE CHAR(2) MEM_ZIP CHAR(5) MEM_BALANCE DECIMAL(10,2) Indexes + rental RENT_NUM DECIMAL(8,0) RENT_DATE DATE ++ MEM_NUM DECIMAL(8,0) Indexes detailrental RENT_NUM DECIMAL(8,0) VID_NUM DECIMAL(8,0) DETAIL_FEE DECIMAL(5,2) DETAIL_DUEDATE DATE DETAIL_RETURNDATE DATE DETAIL_DAILYLATEFEE DECIMAL(5,2) Indexes Increase the price rent fee of movies whose price description is 'New Release' by 1, while decreasing the price rent fee for movies whose price description is 'Discount' by 0.5. Furthermore, you should also increase the daily late fee amount by one for 'New Release only without changing the daily late fee for 'Discount' movies. CASE END SET UPDATE WHERE