Due Date: Feb.,LUTY The purpose of this database trigger is that when one or more copies of a book are sold, the trigger should automatically adjust that book's inventory (quantity on hand) by reducing the inventory accordingly. 1. Log into your online Oracle account and run the Bookstore database script (bookstore.sq!) available in Canvas (Files Data Files) to create the following bookstore tables. (Notice that the last column in the BOOKS table is Quantity on Hand column ORDERS CUSTOMERS Order Firstname Emal Address Shipzip BOOKAUTHOR AUTHOR Reterred ORDERITEMS Tele PubID Cost ISBN Quantity DiscountPUBLISHER Contact Phone 2. Write a trigger to automatically update inventory of books in the books table after a book is sold. Name this trigger as your own laname. Compile the trigger. If correctly compiled, you should see a Trigger output, and your account email and paste it in a Word document. Test the trigger to see if it works properly by doing the following 3. (a) Display the beginning inventory of books (see an example below). Please create a screenshot of the statement and its output, and paste it in the same Word document as above. SELECI 1sbn, title, quantity_on hand "Previoas Inventory Previoas Inventory 1140733 REVENS or 15 959789321 B-BUSINE9 THE EASY NAY 122 0209282519 THE D (b) Sell9 units/copies of the book that has the following ISBN: 3957136468. Create and paste a screenshot of this step showing complete statement, its output and your account. Paste the screenshot in the same Word document. (c) Display books inventory again - the book titled "Holy Grill of Oracle" should now have been reduced by 9 units. Create and paste a screenshot of this step showing statement and its output in the ame Word document 1 SELECt Sabn, title,qaaatit on had "updated CuantLty Updated Quantitz 401140333 REVENGE or NICKEY 8843172113 ATABASE 4. Upload the Word document in Canvas using the Assignments link