(Solved) : 7 Drop Employee Table 8 Rename Employee2 Table Employee 9 Add Comment Department Employee Q30270083 . . . .

7. Drop the EMPLOYEE table.

8. Rename the EMPLOYEE2 table to EMPLOYEE.

9. Add a comment to the DEPARTMENT and EMPLOYEE table definitionsdescribing
the tables (e.g. ‘Employee Information’. Or ‘DepartmentInformation’) Confirm your
additions in the data dictionary. . (Hint: USER_TAB_COMMENTS)

10. Drop the LAST_NAME column from the EMPLOYEE table. Confirm yourmodification
by checking the description of the table.

11. Create the EMPLOYEE2 table based on the structure of the EMPtable. Include only
the EMPNO, ENAME, and DEPTNO columns. Name the columns in your newtable
ID, LAST_NAME, and DEPT_ID, respectively. Mark the DEPT_ID columnin the
EMPLOYEE2 table as UNUSED. Confirm your modification by checkingthe
description of the table.

12. Drop all the UNUSED