please solve this by Oracle SQL Developer/Oracle Live SQL and answer the following question

Also,

this OrdersNT.txt:

Create a TYPE, LineItemADT, to store LineItems

Create a type, LineItemsNT_TAB, to store LineItemADT information. See Object Oriented slides from class. Create a table, Order, with the following columns:

Use the following data for the INSERT statements

This shema for DDL, DML :

create table DEPARTMENT (

DNAME VARCHAR(30),

DNUMBER NUMBER(4) PRIMARY KEY,

MGR_SSN CHAR(9),

MGR_START_DATE DATE);

create table EMPLOYEE (

FNAME VARCHAR(30),

MINIT CHAR(1),

LNAME VARCHAR(30),

SSN CHAR(9) PRIMARY KEY,

BDATE DATE,

ADDRESS VARCHAR(30),

SEX CHAR(1),

SALARY NUMBER(5),

SUPER_SSN CHAR(9),

DNO NUMBER(4));

ALTER TABLE EMPLOYEE ADD CONSTRAINT SEXCHECK CHECK (SEX IN ('M','F'));

ALTER TABLE EMPLOYEE ADD CONSTRAINT SALARYCHECK CHECK (SALARY >= 1000 AND SALARY

ALTER TABLE DEPARTMENT ADD CONSTRAINT dept_mgrssn_fk FOREIGN KEY (MGR_SSN) REFERENCES EMPLOYEE(SSN) ON DELETE CASCADE;

ALTER TABLE EMPLOYEE ADD CONSTRAINT emp_superssn_fk FOREIGN KEY (SUPER_SSN) REFERENCES EMPLOYEE(SSN) ON DELETE CASCADE;

ALTER TABLE EMPLOYEE ADD CONSTRAINT emp_dno_fk FOREIGN KEY (DNO) REFERENCES DEPARTMENT(DNUMBER) ON DELETE CASCADE;

create table DEPT_LOCATIONS(

DNUMBER NUMBER(4),

DLOCATION VARCHAR(20),

PRIMARY KEY(DNUMBER,DLOCATION));

ALTER TABLE DEPT_LOCATIONS ADD CONSTRAINT deptloc_dnum_fk FOREIGN KEY (DNUMBER) REFERENCES DEPARTMENT(DNUMBER) ON DELETE CASCADE;

create table PROJECT(

PNAME VARCHAR(30),

PNUMBER NUMBER PRIMARY KEY,

PLOCATION VARCHAR(30),

DNUM NUMBER(4));

ALTER TABLE PROJECT ADD CONSTRAINT proj_dnum_fk FOREIGN KEY (DNUM) REFERENCES DEPARTMENT(DNUMBER) ON DELETE CASCADE;

create table WORKS_ON(

ESSN CHAR(9),

PNO NUMBER,

HOURS NUMBER(4,2),

PRIMARY KEY(ESSN,PNO));

ALTER TABLE WORKS_ON ADD CONSTRAINT workson_essn_fk FOREIGN KEY (ESSN) REFERENCES EMPLOYEE(SSN) ON DELETE CASCADE;

ALTER TABLE WORKS_ON ADD CONSTRAINT workson_pno_fk FOREIGN KEY (PNO) REFERENCES PROJECT(PNUMBER) ON DELETE CASCADE;

create table DEPENDENT(

ESSN CHAR(9),

DEPENDENT_NAME VARCHAR(30),

SEX CHAR(1),

BDATE DATE,

RELATIONSHIP VARCHAR(30),

PRIMARY KEY(ESSN,DEPENDENT_NAME));

ALTER TABLE DEPENDENT ADD CONSTRAINT dep_essn_fk FOREIGN KEY (ESSN) REFERENCES EMPLOYEE(SSN) ON DELETE CASCADE;

INSERT INTO DEPARTMENT VALUES('Research',5,null,to_date('1988-05-22','yyyy-mm-dd'));

INSERT INTO DEPARTMENT VALUES('Administration',4,null,to_date('1995-01-01','yyyy-mm-dd'));

INSERT INTO DEPARTMENT VALUES('Headquarters',1,null,to_date('1981-06-19','yyyy-mm-dd'));

INSERT INTO EMPLOYEE VALUES('James','E','Borg','888665555',to_date('1937-11-10', 'yyyy-mm-dd'), '450 Stone,Houston,TX','M',55000,null,'1');

INSERT INTO EMPLOYEE VALUES('Franklin','T','Wong','333445555',to_date('1955-12-08','yyyy-mm-dd'),'638 Voss,Houston,TX','M',40000,'888665555','5');

INSERT INTO EMPLOYEE VALUES('John','B','Smith','123456789',to_date('1965-01-09','yyyy-mm-dd'),'731 Fondren,Houston,TX','M',30000,'333445555','5');

INSERT INTO EMPLOYEE VALUES('Jennifer','S','Wallace','987654321',to_date('1941-06-20', 'yyyy-mm-dd'),'291 Berry,Bellaire,TX','F',43000,'888665555','4');

INSERT INTO EMPLOYEE VALUES('Alicia','J','Zelaya','999887777',to_date('1968-01-19', 'yyyy-mm-dd'),'3321 Castle,Spring,TX','F',25000,'987654321','4');

INSERT INTO EMPLOYEE VALUES('Ramesh','K','Narayan','666884444',to_date('1962-09-15', 'yyyy-mm-dd'),'975 Fire Oak,Humble,TX','M',38000,'333445555','5');

INSERT INTO EMPLOYEE VALUES('Joyce','A','English','453453453',to_date('1972-07-31', 'yyyy-mm-dd'),'5631 Rice,Houston,TX','F',25000,'333445555','5');

INSERT INTO EMPLOYEE VALUES('Ahmad','V','Jabbar','987987987',to_date('1969-03-29', 'yyyy-mm-dd'),'980 Dallas,Houston,TX','M',25000,'987654321','4');

UPDATE DEPARTMENT SET MGR_SSN='333445555' WHERE DNUMBER=5;

UPDATE DEPARTMENT SET MGR_SSN='987654321' WHERE DNUMBER=4;

UPDATE DEPARTMENT SET MGR_SSN='888665555' WHERE DNUMBER=1;

INSERT INTO DEPT_LOCATIONS VALUES(1,'Houston');

INSERT INTO DEPT_LOCATIONS VALUES(4,'Stafford');

INSERT INTO DEPT_LOCATIONS VALUES(5,'Bellaire');

INSERT INTO DEPT_LOCATIONS VALUES(5,'Sugarland');

INSERT INTO DEPT_LOCATIONS VALUES(5,'Houston');

INSERT INTO PROJECT VALUES('ProductX',1,'Bellaire',5);

INSERT INTO PROJECT VALUES('ProductY',2,'Sugarland',5);

INSERT INTO PROJECT VALUES('ProductZ',3,'Houston',5);

INSERT INTO PROJECT VALUES('Computerization',10,'Stafford',4);

INSERT INTO PROJECT VALUES('Reorganization',20,'Houston',1);

INSERT INTO PROJECT VALUES('Newbenefits',30,'Stafford',4);

INSERT INTO WORKS_ON VALUES('123456789',1,32.5);

INSERT INTO WORKS_ON VALUES('123456789',2,7.5);

INSERT INTO WORKS_ON VALUES('666884444',3,40.0);

INSERT INTO WORKS_ON VALUES('453453453',1,20.0);

INSERT INTO WORKS_ON VALUES('453453453',2,20.0);

INSERT INTO WORKS_ON VALUES('333445555',2,10.0);

INSERT INTO WORKS_ON VALUES('333445555',3,10.0);

INSERT INTO WORKS_ON VALUES('333445555',10,10.0);

INSERT INTO WORKS_ON VALUES('333445555',20,10.0);

INSERT INTO WORKS_ON VALUES('999887777',30,30.0);

INSERT INTO WORKS_ON VALUES('999887777',10,10.0);

INSERT INTO WORKS_ON VALUES('987987987',10,35.0);

INSERT INTO WORKS_ON VALUES('987987987',30,5.0);

INSERT INTO WORKS_ON VALUES('987654321',30,20);

INSERT INTO WORKS_ON VALUES('987654321',20,15.0);

INSERT INTO WORKS_ON VALUES('888665555',20,null);

INSERT INTO DEPENDENT VALUES('333445555','Alice','F',to_date('1986-04-05','yyyy-mm-dd'),'Daughter');

INSERT INTO DEPENDENT VALUES('333445555','Theodore','M',to_date('1983-10-25','yyyy-mm-dd'),'Son');

INSERT INTO DEPENDENT VALUES('333445555','Joy','F',to_date('1958-05-03','yyyy-mm-dd'),'Spouse');

INSERT INTO DEPENDENT VALUES('987654321','Abner','M',to_date('1942-02-28','yyyy-mm-dd'),'Spouse');

INSERT INTO DEPENDENT VALUES('123456789','Michael','M',to_date('1988-01-04','yyyy-mm-dd'),'Son');

INSERT INTO DEPENDENT VALUES('123456789','Alice','F',to_date('1988-12-30','yyyy-mm-dd'),'Daughter');

INSERT INTO DEPENDENT VALUES('123456789','Elizabeth','F',to_date('1967-05-05','yyyy-mm-dd'),'Spouse');

commit;

.Write an UPDATE statement to change the quantity to 10 for LineltemNumber 18 on Order number 100 Paste the UPDATE statement below .Below, paste the output of executing the query: "SELECT * from Order" after running the UPDATE in the previous question. Although this question is worth 0 points, if it is blank, there will be a 1 point deduction if the question to which it applies is correct Example DAta (To show datatype, multiple values separated by commas to show possible values ) ] Column Name LineItemNumber ProductID Quantity PricePerUnit Discount 1, 2, 3 13, 27, 104234 3, 55, 2000, 99999 39.99, 12.00, 4000.03 0.1, 0.15, 0.01, 0.0