Assignment: SQL Transaction using the Homework Database: for the Little League Baseball Team Database

This is not a Required Assignment

This is an Optional 100 Point Extra Credit Assignment

For this assignment, students will write the SQL script to invoke SQL Transaction Framework for the Homework Database, the  Little League Baseball Team Database, .  You should use  the link to the SQL Transactions Tutorial as a guide to creating the SQL script for this assignment 

The sequence of the statements in the script should follow the same framework as the script in the Tutorial.  They should follow this order

Create the homework database

use the homework database

Insert Sample data into the tables

create a sample script to implement an SQL Transaction.

 use tables and data in from the Homework Database

To better illustrate occurrences in this assignment, it is best to create two separate login accounts using DCL Statements and privileges

1. Create the homework database
   
   
2. use the homework database
   
   
3. Insert Sample data into the tables
   
   
4. create two new fictitious user accounts
   
   
5. assign appropriate privileges to the users for the assignment
   
   
6. log in to one of the new accounts 
   
   
7. Activate transaction mode in the session
   
   
8. The script will illustrate listing the state of the information prior to the transaction
   
   
9. The script will perform the DML operation of the transaction.  This can be the insertion, deletion, or modification of data in the homework database
   
   
10. Log in to the second user account
    
    
11. Run the script that will perform a rollback of the transaction
    
    
12. The script will commit the transaction 

Submit an SQL Text File for the SQL portion of this assignment.  An SQL Text File is a text file with a "SQL" extension on the file name. 

• The script should be well documented with comments
  
  
• All the scripts should be placed in one file
  
  
• The script should run continuously without errors