$(5-2)$ Question $1$:

Write a script that does the following:

$$ Turn off Autocommit

$$ Insert a new row into sec$0502\_$departments

$$ Save this change by issuing a commit command

$$ Insert another new row into sec$0502\_$departments

$$ Undo this change by issuing a rollback command

$$ Display all the rows in sec$0502\_$departments

$(5-3)$ Question $2$:

Write a script that does the following:

$$ Turn off Autocommit

$$ Insert a new row into sec$0503\_$savings$\_$accounts with all of data from the

sec$0503\_$checking$\_$accounts table for customer $$BOB WILKINS$$

$$ Delete customer $$BOB WILKINS$$ data from the sec$0503\_$checking$\_$accounts table

$$ Commit these changes

$(5-3)$ Question $3$:

Write a script that does the following:

$$ Turn off Autocommit

$$ Update sec$0503\_$savings$\_$accounts to decrease the balance of customer $$FRED BOYD$$ by

$$20,000$

$$ Update sec$0503\_$checking$\_$accounts to increase the balance of customer $$FRED BOYD$$

by $$20,000$

$$ Display all rows in sec$0503\_$savings$\_$accounts

$$ Display all rows in sec$0503\_$checking$\_$accounts

$$ Rollback these changes