Question: Create one sql script file to complete the following. You cannot run separate SQL statements for the homework. You will also need to place a

Create one sql script file to complete the following. You cannot run separate SQL statements for the homework. You will also need to place a semicolon after each SQL statement, a requirement for SQL files containing multiple SQL statements

Lesson 11
1. Create a comment for every table in the database you created in Week 1.For reference, look back to Week 1 assignments, Write the sql statement that displays all tables in the data dictionary that have comments.
2. Create a view called EMP_VU based on the employee number, employee name, and department number from the EMP table. Change the heading for the employee name to EMPLOYEE. Display the contents of the EMP_UV view.
3. Select the view name and text from the data dictionary USER_VIEWS.
4. Using your EMP_UV, enter a query to display all employee names and department numbers.
5. Create a view named DEPT20 that contains the employee number, employee name, and department number for all employees in department 20. Label the view columns EMPLOYEE_ID, EMPLOYEE, and DEPARTMENT_ID. Do not allow an employee to be reassigned to another department through the view.
6. Display the structure and contents of the DEPT20 view. Attempt to reassign Yang to department 20.
7. Create a view called SALARY_VU based on the employee name, department name, salary, and salary grade for all employees. Label the column Employee, Department, Salary, and Grade, respectively. Using your view, display Employee, Department, Salary, and Grade
Lesson 13
1. Create a sequence to be used with the primary key column of the DEPARTMENT table. The sequence should start at 80 and have a maximum value of 260. Have your sequence increment by ten numbers. Name the sequence DEPT_ID_SEQ.
2. Write a script to display the following information about your sequences: sequence name, maximum value, increment size, and the last number.
3. Write an interactive script to insert a row into the DEPARTMENT table. Be sure to use the sequence that you created for the ID column. Create a customized prompt to enter the department name.

DROP TABLE EMP;

DROP TABLE DEPT;

DROP TABLE SALGRADE;

DROP TABLE CUSTOMER;

CREATE TABLE DEPT (

DEPTNO NUMBER(2) NOT NULL,

DNAME VARCHAR2(14),

LOC VARCHAR2(13),

CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));

INSERT INTO DEPT VALUES (10,'ADMIN','OMAHA');

INSERT INTO DEPT VALUES (20,'OPERATIONS','ST LOUIS');

INSERT INTO DEPT VALUES (30,'TRADING','SEATTLE');

CREATE TABLE EMP (

EMPNO NUMBER(4) NOT NULL,

ENAME VARCHAR(45),

JOB VARCHAR2(9),

MGR NUMBER(4) CONSTRAINT EMP_MGR_FK REFERENCES EMP (EMPNO),

HIREDATE DATE,

SAL NUMBER(7,2),

COMM NUMBER(7,2),

DEPTNO NUMBER(2) NOT NULL,

CONSTRAINT EMP_DEPTNO_FK FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),

CONSTRAINT EMP_EMPNO_PK PRIMARY KEY (EMPNO));

INSERT INTO EMP VALUES (7839,'PLISKIN','PRESIDENT',NULL,TO_DATE('17-NOV-1981','DD-MON-YYYY'),5000,NULL,10);

INSERT INTO EMP VALUES (7698,'BENNIE','MANAGER',7839,TO_DATE('1-MAY-1981','DD-MON-YYYY'),2850,NULL,20);

INSERT INTO EMP VALUES (7782,'SINGH','MANAGER',7839,TO_DATE('9-JUN-1981','DD-MON-YYYY'),2450,NULL,10);

INSERT INTO EMP VALUES (7566,'KOBAYASHI','MANAGER',7839,TO_DATE('2-APR-1981','DD-MON-YYYY'),2975,NULL,30);

INSERT INTO EMP VALUES (7654,'YANG','BROKER',7566,TO_DATE('28-SEP-1981','DD-MON-YYYY'),1250,1400,30);

INSERT INTO EMP VALUES (7499,'RODRIGUEZ','BROKER',7566,TO_DATE('20-FEB-1981','DD-MON-YYYY'),1600,1200,30);

INSERT INTO EMP VALUES (7844,'PATEL','BROKER',7566,TO_DATE('8-SEP-1981','DD-MON-YYYY'),1500,1000,30);

INSERT INTO EMP VALUES (7845,'CARON','BROKER',7566,TO_DATE('8-SEP-1981','DD-MON-YYYY'),1500,1000,30);

INSERT INTO EMP VALUES (7900,'SMITH','CLERK',7782,TO_DATE('3-DEC-1981','DD-MON-YYYY'),950,NULL,10);

INSERT INTO EMP VALUES (7521,'HARRISON','CLERK',7698,TO_DATE('22-FEB-1981','DD-MON-YYYY'),925,NULL,20);

INSERT INTO EMP VALUES (7902,'KENT','CLERK',7566,TO_DATE('3-DEC-1981','DD-MON-YYYY'),1000,NULL,30);

INSERT INTO EMP VALUES (7369,'RICE','CLERK',7782,TO_DATE('17-DEC-1980','DD-MON-YYYY'),1000,NULL,10);

INSERT INTO EMP VALUES (7788,'RADNER','ANALYST',7698,TO_DATE('09-DEC-1982','DD-MON-YYYY'),2200,NULL,20);

INSERT INTO EMP VALUES (7876,'MARTINEZ','ANALYST',7698,TO_DATE('12-JAN-1983','DD-MON-YYYY'),2000,NULL,20);

INSERT INTO EMP VALUES (7934,'ZHAO','ANALYST',7698,TO_DATE('23-JAN-1982','DD-MON-YYYY'),2300,NULL,20);

CREATE TABLE SALGRADE (

GRADE NUMBER,

LOSAL NUMBER,

HISAL NUMBER);

INSERT INTO SALGRADE VALUES (1,700,1200);

INSERT INTO SALGRADE VALUES (2,1201,1400);

INSERT INTO SALGRADE VALUES (3,1401,2000);

INSERT INTO SALGRADE VALUES (4,2001,3000);

INSERT INTO SALGRADE VALUES (5,3001,9999);

CREATE TABLE CUSTOMER (

CUSTID NUMBER (6) NOT NULL,

ADDRESS VARCHAR2 (40),

CITY VARCHAR2 (30),

STATE VARCHAR2 (2),

ZIP VARCHAR2 (9),

AREA NUMBER (3),

PHONE VARCHAR2 (9),

EMAIL VARCHAR2 (40),

BALANCE NUMBER (12,2),

CONSTRAINT CUSTOMER_CUSTID_PK PRIMARY KEY (CUSTID),

CONSTRAINT CUSTOMER_CUSTID_CK CHECK (CUSTID > 0));