Week $2$ Performance Assessment: Transaction and Data Dictionary

The following questions come from the Check your understanding examples of each section of Chapter $5$ in your textbook.

After you are finished, please submit a Microsoft Word file that contains screenshots of the SQL queries, resulting output, and contains a comment in the queries showing your name. Your document should be named

W$2\_$PA$\_$TransactionDataDictionary$\_$Lastname.docx.

$(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 WILKIN$$S$\text{'}$

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