Assignment Week 7 for 50 points, due SUNDAY 05/26/2013.

The goal of test week 7 is to assure that students have read / reviews chapters 9 and 10 from Oracle 10g Text Book.

Using your credentials, via PuTTY Session, logon to SQL> and perform Practice 9 as follows.

As you perform the steps, take screenshot of your work (snapshots), copy your results to a word document, save to your desktop as a word 2003 format document (after you have copied ALL your screenshots – one file), then submit results. Please take screenshot of ALL your steps, and combine all them as one single file.

Show all your steps.

I’ve provided a sample code below, but your code may differ from that. It is just a sample.

Please also see the Table Document that is posted separately to see details of any table definitions in case you need it. Please note that for “Table Employees” due to length of the table description and page size limit, I have broken it into 2 parts for better visibility, please make sure to use all the given attributes from the table. Also, I have included the same table as one part if you prefer to see it in one piece.

Please see the sample syntax at the end of the practice definition:

The problem is given in “Practice 9: Overview” as below, review the problem, run the required statements to create the required table, take snapshot, save to a word doc, verifying the table exist, take snapshot, and then CREATE TABLE employees2 AS, using “AS” and taking / saving snapshot, drop table, take snapshot, save to the same word doc,

Sample Code:

CREATE TABLE dept
(id NUMBER(7)CONSTRAINT department_id_pk PRIMARY KEY,
name VARCHAR2(25));

DESCRIBE dept

INSERT INTO dept
SELECT department_id, department_name
FROM departments;

CREATE TABLE emp
(id NUMBER(7),
last_name VARCHAR2(25),
first_name VARCHAR2(25),
dept_id NUMBER(7)
CONSTRAINT emp_dept_id_FK REFERENCES dept…