Perform SQL INSERT, UPDATE and DELETE queries

Description

Write a series of Oracle SQL statements to modify the OrderEntry database which consists of the tables and rows as shown on pages 121 - 123 of your text.

This assignment will be completed using Oracle. You may use Oracle 9i or later. The CS Athena remote terminal server has SQL*Plus installed and available for student use. Instructions for using the Athena server can be found at
http://rbhilton.com/wsucs/cs2550/CS2550TSInstructions.pdf

Complete the assignment by performing the following

1. Connect to the WSU/CS Oracle Server, or any other available Oracle server using SQL*Plus.
   Instructions for connecting to terminal server and logging on to SQL*Plus can be found at:
   http://rbhilton.com/wsucs/cs2550/CS2550TSInstructions.htm
   
   
2. Download the script file
   http://rbhilton.com/wsucs/cs2550/OrderEntryOracleLoad.sql
   This script file will be used to populate the Order Entry database with data.
   
   
3. Connect to the titan Oracle server and run the script.
   If you are connecting to Oracle via Athena follow the instructions for running scripts remotely:
   
   
4. Once you have the tables loaded, turn on spooling to a file CS2550A05Spool.txt
   
   
5. Perform the Part 2 steps 1-10 on page 127 of your text.
   
   
6. Turn off Spooling

Number each SQL statement and put them into a single text file named CS2550A05.txt  and upload the file using the Assignment Uploader.