Home /
Expert Answers /
Computer Science /
execute-the-sql-code-in-table-1-below-there-are-no-syntax-errors-in-transaction-1-and-2-10-poin-pa531
(Solved): Execute the SQL code in TABLE 1 below. There are no syntax errors in transaction 1 and 2 . (10 poin ...
Execute the SQL code in TABLE 1 below. There are no syntax errors in transaction 1 and 2 . (10 points) Enter the following directly in TABLE 1 for each time period - Output from transaction 1 and transaction 2. For instance, after executing the SQL at each time period, enter the output displayed to the screen. Enter the output in the columns labeled output transaction 1 and output transaction 2. - After executing the SQL at each time period, identify the values saved to the BAL column in the - After executing the SQL at each time period, identify the values saved to the BAL column in the account table for CID=500. Enter your values in the column labeled Bal soo in account table
1. After executing transaction 1 and transaction 2:Output transaction 1: None (UPDATE statement)Output transaction 2: None (UPDATE statement)Bal600 in account table: 1900 (2000 - 100)Bal500 in account table: 940 (1000 - 60)In the first step, two UPDATE statements are executed:Transaction 1: UPDATE ACCOUNT SET BAL = BAL - 60 WHERE CID = 500;Transaction 2: UPDATE ACCOUNT SET BAL = BAL - 100 WHERE CID = 600;These statements deduct 60 from the balance of CID 500 and 100 from the balance of CID 600.