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

$(5-5)$ Question $4$:

Write a script that does the following:

Display all the data in $sec0505$ foods

Create a view of the foods table, including all the columns and rows

Insert a new row into the view

Update the view, setting menu$\_$item to $20$ and description to 'CARROTS' where the description is currently 'BROCCOLI'

Delete a row from the view

Display all the data in the view

Display all the data in sec$0505$ foods

$(5-11)$ Question $5$:

List the names of all the tables you own.

$(5-12)$ Question $6$:

List the names of all the views you own.

$(5-14)$ Question $7$:

Use the Data Dictionary to find the names of all the columns of the $L_E$MPLOYEES table.

$(5-15)$ Question $8$:

Use the Data Dictionary to find the primary key of the L$\_$EMPLOYEES table.