File made by Drew Hengehold Function created. No errors. Function created. No errors. Function created. No errors. Procedure created. No errors. ========Testing item_sold======== +-+-+-+-+-+-+-+-+-+ (Test 1 of item_sold) Should output: employee id = 000001, item id = 001, and customer id = 200001 Additionally, the sale_item table should have 2 less black teas, and the sale table should have one more entry +-+-+-+-+-+-+-+-+-+ Customer id is: 200001 Item id is: 001 Employee id is: 000001 Transaction Complete PL/SQL procedure successfully completed. SAL SALE_AMT CUST_N EMPL_I --- ---------- ------ ------ 1 6 200002 000002 2 2 200004 000002 3 2 200006 000002 4 2 200008 000006 5 2 200010 000002 6 2 200012 000002 7 2 200014 000006 8 2 200017 000006 9 2 200019 000002 10 2 200015 000006 11 2 200001 000001 11 rows selected. ITE I ITEM_NAME STOCK_QUANT ITEM_PRICE --- - ------------------------------ ----------- ---------- 000 t honey lavender 30 2 001 t black 28 2 002 t earl grey 30 2 003 t green 30 2 004 t peppermint 30 2 005 t english breakfast 30 2 006 t cinnamon spice 30 2 007 t chamomile 30 2 008 t jasmine 30 2 009 t lemon bolm 30 2 010 t raspberry 30 2 ITE I ITEM_NAME STOCK_QUANT ITEM_PRICE --- - ------------------------------ ----------- ---------- 011 f bbq 20 3 012 f salt and vinegar 20 3 013 f ham and cheese 5 014 f pretzels 20 2 015 f salad 3 016 f blueburry muffin 10 1.5 017 f chocolate muffin 10 1.5 018 f chocolate chip muffin 10 1.5 019 f chicken sandwhich 5 020 f fries 40 2.5 21 rows selected. (Test 2 of item_sold) Should output: employee id = -1, item id = 001, and customer id = 200001 The output should be transaction failed, and no updates should be made to the table so black tea should be 28, and the last sale number should be 11 +-+-+-+-+-+-+-+-+-+ Customer id is: 200001 Item id is: 001 Employee id is: -1 Transaction Failure PL/SQL procedure successfully completed. SAL SALE_AMT CUST_N EMPL_I --- ---------- ------ ------ 1 6 200002 000002 2 2 200004 000002 3 2 200006 000002 4 2 200008 000006 5 2 200010 000002 6 2 200012 000002 7 2 200014 000006 8 2 200017 000006 9 2 200019 000002 10 2 200015 000006 11 2 200001 000001 11 rows selected. ITE I ITEM_NAME STOCK_QUANT ITEM_PRICE --- - ------------------------------ ----------- ---------- 000 t honey lavender 30 2 001 t black 28 2 002 t earl grey 30 2 003 t green 30 2 004 t peppermint 30 2 005 t english breakfast 30 2 006 t cinnamon spice 30 2 007 t chamomile 30 2 008 t jasmine 30 2 009 t lemon bolm 30 2 010 t raspberry 30 2 ITE I ITEM_NAME STOCK_QUANT ITEM_PRICE --- - ------------------------------ ----------- ---------- 011 f bbq 20 3 012 f salt and vinegar 20 3 013 f ham and cheese 5 014 f pretzels 20 2 015 f salad 3 016 f blueburry muffin 10 1.5 017 f chocolate muffin 10 1.5 018 f chocolate chip muffin 10 1.5 019 f chicken sandwhich 5 020 f fries 40 2.5 21 rows selected.