The question SQL Oracle Database currently using Oracle SQL Developer Write a script with three commands. An INSERT statement inserting a new record in car table. You will have to deal with referential integrity constraints caused by purchinvno, custname etc. Insert values for all columns in the car table and make sure that the value for carlistprice is between 1 and 249999.99. Write an UPDATE statement and update the carlistprice to a value that is either negative or greater than 250000. Follow by a COMMIT. Execute the script and show the response from the server.

I am not sure how to do this? Does it just want a simple insert statement? do I do a if statement?

Just focus on the car table this is the best schema I have

Specialty Imports E-R Diagram CUSTOMER custame VARCHAR2:20 custstreet VARCHAR2/20) NOT NULL custcity VARCHAR2(20) NOT NULL custprovince CHAR(2) NOT NULL DEFAULT ON custpostal CHAR(7) NOT NULL custhphone CHAR(13) NOT NULL custophone CHAR(13) NOT NULL CAR carserial CHAR(3) custame VARCHAR2(20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL caryear CHAR(4) NOT NULL extcolour VARCHAR2(12) NOT NULL cartrim VARCHAR2(16) NOT NULL enginelype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinino CHAR(6) purchcost NUMBER(92) freightcast NUMBER(92) carlistprice NUMBER(92) SALEINV osalino CHAR(5) saledate DATE NOT NULL salesman VARCHAR2(20) NOT NULL custame VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL instre CHAR(1) inscollision CHAR(1) insliability CHAR(1) insproperty CHAR(1) tarate NUMBER(4.2) DEFAULT 13.0 licte NUMBER(6.2) discount NUMBER(82) commission NUMBER(8,2) carsaleprice NUMBER(92) PROSPECT custame VARCHAR2(20) NOT NULL carmale VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) caryear CHAR(4) carcolour VARCHAR2(12) cartrim VARCHAR2(16) optioncode CHAR214 SERVINV servinvno CHAR(5) servdate DATE NOT NULL Custname VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL parts.cost NUMBER(72) laborcost NUMBER(7.2) taxrate NUMBER(4.2) DEFAULT 13.0 SERVWORK servinno CHAR(5) wordesc VARCHAR2(80) PURCHINV purchinino CHAR(6) purchfrom VARCHAR2(15) purchdate DATE TRADEINV saleinvno CHAR(6) carserial CHAR(8) tradeallow NUMBER/9,2) EMPLOYEE empname VARCHAR2(20) standate DATE NOT NULL commissionate NUMBER(3.1) VARCHAR2(26) manager VARCHAR2(20) OPTIONS tioncode CHAR4) optiondesc VARCHAR2(30) optioncost NUMBER(72) option istorice NUMBER(7.2) BASEOPTION Optioncode CHAR14 carserial CHAR INVOPTION saleinno CHARIO optioncode CHAR(4) optionpnice NUMBER(72) Specialty Imports E-R Diagram CUSTOMER custame VARCHAR2:20 custstreet VARCHAR2/20) NOT NULL custcity VARCHAR2(20) NOT NULL custprovince CHAR(2) NOT NULL DEFAULT ON custpostal CHAR(7) NOT NULL custhphone CHAR(13) NOT NULL custophone CHAR(13) NOT NULL CAR carserial CHAR(3) custame VARCHAR2(20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL caryear CHAR(4) NOT NULL extcolour VARCHAR2(12) NOT NULL cartrim VARCHAR2(16) NOT NULL enginelype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinino CHAR(6) purchcost NUMBER(92) freightcast NUMBER(92) carlistprice NUMBER(92) SALEINV osalino CHAR(5) saledate DATE NOT NULL salesman VARCHAR2(20) NOT NULL custame VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL instre CHAR(1) inscollision CHAR(1) insliability CHAR(1) insproperty CHAR(1) tarate NUMBER(4.2) DEFAULT 13.0 licte NUMBER(6.2) discount NUMBER(82) commission NUMBER(8,2) carsaleprice NUMBER(92) PROSPECT custame VARCHAR2(20) NOT NULL carmale VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) caryear CHAR(4) carcolour VARCHAR2(12) cartrim VARCHAR2(16) optioncode CHAR214 SERVINV servinvno CHAR(5) servdate DATE NOT NULL Custname VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL parts.cost NUMBER(72) laborcost NUMBER(7.2) taxrate NUMBER(4.2) DEFAULT 13.0 SERVWORK servinno CHAR(5) wordesc VARCHAR2(80) PURCHINV purchinino CHAR(6) purchfrom VARCHAR2(15) purchdate DATE TRADEINV saleinvno CHAR(6) carserial CHAR(8) tradeallow NUMBER/9,2) EMPLOYEE empname VARCHAR2(20) standate DATE NOT NULL commissionate NUMBER(3.1) VARCHAR2(26) manager VARCHAR2(20) OPTIONS tioncode CHAR4) optiondesc VARCHAR2(30) optioncost NUMBER(72) option istorice NUMBER(7.2) BASEOPTION Optioncode CHAR14 carserial CHAR INVOPTION saleinno CHARIO optioncode CHAR(4) optionpnice NUMBER(72)