database management 2

1. Exercise 1 from Chapter 14 of the book. Refer to lecture WK3-Ch14-Scripts(1) Slide#9. Write a script that declares and sets a variable equal to the total outstanding balance due in the Invoices table (TotalDue). If the outstanding balance due is less than $10,000, the script should display the message Balance due is less than $10,000". If the outstanding balance due is greater than $10,000, the script should display a result set (the table below) consisting of Vendor Name, Invoice Number, InvoiceDueDate and the Balance (Invoice Total PaymentTotal - CreditTotal) for each invoice with a balance due, in other words, with a balance greater than 0. Sort result such that the earliest due date appears first. InvoiceNumb Vendor Name InvoiceDueDate Balance Data Reproductions Corp 39104 4/9/2012 0:00 85.31 Ingram 31361833 4/10/2012 0:00 579.42 Federal Express Corporation 963253264 4/17/2012 0:00 52.25 Cardinal Business Media, Inc. 134116 4/17/2012 0:00 90.36 Federal Express Corporation 263253268 4/20/2012 0:00 59.97 Federal Express Corporation 263253270 4/21/2012 0:00 67.92 Federal Express Corporation 263253273 4/21/2012 0:00 30.75 Malloy Lithographing Inc P-0608 4/22/2012 0:00 19351.18 Ford Motor Credit Company 9982771 4/23/2012 0:00 503.2 Malloy Lithographing Inc 0-2436 4/30/2012 0:00 10976.06 Blue Cross 547480102 4/30/2012 0:00 224 er 1 Exercise 1 from Chapter 14 of the book. Refer to lecture WKS-Ch14-Scripts(1) silde19. Write a script that declares and sets a variable equal to the total outstanding balance due in the Invoices table Catalue) If the outstanding balance due is less than $10,000, the script should display the message "Balance due is less than $10,000 If the outstanding balance due is greater than $10,000, the script should display a result set the table below) consisting of Vendor Name. Invoice Numko lnxeica Rus Date and the Balance (lxgistatal - PaymentTotal-Sceditterat) for each Invoice with a balance due, in other words, with a balance greater than 0. Sort result such that the earliest due date appears first. Vender Name InvoiceNumbet InvoiceRusRats Balance Data Reproductions Corp 39104 4/9/2012 0:00 85.51 Ingram 31361833 4/10/20120.00 579,42 Federal Express Corporation 963253264 4/17/20120:00 52 25 Cardinal Business Media, Inc. 134116 4/17/2012 000 90.36 Federal Express Corporation 263253268 4/20/2012 0:00 59.97 Federal Express Corporation 263253220 4/21/20120.00 67,92 Federal Express Corporation 263253273 4/21/2012 0:00 30.75 Malloy Lithographing me P-01608 4/22/20120:00 1935118 Ford Motor Credit Company 9992271 4/25/20120.00 5032 Malo Lithographinging 0-2456 /30/20120.00 1097606 Be Cras SAYASADA ar 0:00 224 Dracus