database managenent oracle sql tabels are created just use your abbrivations

with regard to the tables customer, invoice,line, and product

1) Change the Law Date to 10-Mar-05 for invoices that the line price in between $10 and $20. 2) Change the vendor code of products to 999 if the line member of product is 3. 3) Change the customer last name to Smith for customers with invoice number 1004. 4) Change product price by 10% for products that are in line number 3. 5) Increase the Line Price of products by 12.5 if the vendor code is 232. 6) Count number of tuples in Line table if line price is greater than the average of the line prices. 7) Computer the sum of the product price in product table for invoice numbers 1001 or 1002. S) Display all tables fable Invoi 2 P. Key: ZNY_NUMBER INV_NUMBER CUS_cope INV_DATE 1001 10014 08-Mar-00 1002 10011 08-Mar-08 1003 16012 08-Mar-08 1004 10011 De Mar-08 table : cela fomer P. Ky: cus-CODE CUB_CODE CUS LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE 10010 Rames Alfred A 618 844-2573 10011 Dunne Loone K 713 894-1238 10012 Benih Kathy w 615 694-2285 10013 Olowald Paul F 615 894-2180 10014 Orlando Wyron F 615 222-1672 10016 Brown James 816 207-1228 10017 Wilamo George 515 290-2656 10018 fariss Arne 713 382-7185 10019 Smi Olotte K 815 297-3809 table: Line Key : INV_NUMBER,LINE_NUMBER INV NUMBER LINE_NUMBER PROD_CODE LINE_UNITS LINE_PRICE 1001 123_21UUY 189.99 1001 2 SRE-857UO 2.90 1002 QER-34258 18.83 1003 1 zZXJ02450 6.79 1000 2 BRE-657UG 2.90 1004 001278_AB 12.95 1004 2 SRE-657UG 2.90 table : Product P. Key: PROD_ CODE PROD_CODE PROD_DESCRIPT PROD_PRICE PROD_ON_HAND VEND CODE 001278 AB Claw hammer 12.95 23 232 123_210UY Housette chansow. 16 In bat 183.90 4 235 GER-34250 Sledgehammer 16_J. 18.65 231 SRE-55700 Balita 2.99 15 232 2ZXJ32450 Slape. 12-l length 6.70 235