Practice 8

Practice 8 - 4. Modify the EMPLOYEE table to allow for...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENT FOR AST AND ANT JUNE 2004(2nd August 2004) Submission date: 3rd August 2004 PRACTICE 8 1. Create the DEPARTMENT table based on the table instance chart given below. Enter the syntax in a script called p10q1.sql , then execute the script to create the table. Confirm that the table is created. Name Null? Type ---------- -------- ----------- ID NUMBER(7) NAME VARCHAR2(25) 2. Populate the DEPARTMENT table with data from the DEPT table. Include only columns that you need. 3. Create the EMPLOYEE table based on the table instance chart given below. Enter the syntax in a script called p10q3.sql , and then execute the script to create the table. Confirm that the table is created.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4. Modify the EMPLOYEE table to allow for longer employee last names. Confirm your modification. 5. Confirm that both the DEPARTMENT and EMPLOYEE tables are stored in the data dictionary. ( Hint : USER_TABLES) 6. Create the EMPLOYEE2 table based on the structure of the EMP table, include only the EMPNO, ENAME and DEPTNO columns. Name the columns in your new table ID, LAST_NAME and DEPT_ID, respectively. 7. Drop the EMPLOYEE table. 8. Rename the EMPLOYEE2 table to EMPLOYEE. 9. Add a comment to the DEPARTMENT and EMPLOYEE table definitions describing the tables. Confirm your additions in the data dictionary....
View Full Document

Ask a homework question - tutors are online