(Solved) : 1 Create Department Table Based Following Table Instance Chart Enter Syntax Script Called Q30270077 . . .
1. Create the DEPARTMENT table based on the following tableinstance chart. Enter
the syntax in a script called p10q1.sql, then execute the script tocreate 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 following tableinstance chart. Enter the
syntax in a script called p10q3.sql, and then execute the script tocreate the table.
Confirm that the table is created.
4. Modify the EMPLOYEE table to allow for longer employee lastnames. Confirm your
modification.
5. Confirm that both the DEPARTMENT and EMPLOYEE tables arestored in the data
dictionary. (Hint: USER_TABLES)
6. 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.
Column Name Key Type Nulls/Unique FK Table FK Col umn Datatype Length Id Name Number Varchar2 25 Show transcribed image text
Expert Answer
Answer to 1 Create Department Table Based Following Table Instance Chart Enter Syntax Script Called Q30270077 . . .
OR