Question: can you please help writenthis code use example for help Insert into Project Values (Data Mining'; 99, Southaven', 55 ). Insert into department values (MIS:

can you please help writenthis code use example for help
can you please help writenthis code use example for help Insert into
Project Values (Data Mining'; 99, Southaven', 55 ). Insert into department values

Insert into Project Values (Data Mining'; 99, Southaven', 55 ). Insert into department values (MIS: 11 : 888665555 to date(0619/2000, 'mmidd yyyy')); Update Woeks ot Set PNO =23 Where ESSN =123456769, Update Project See Dnum =7 Where Pnamber =30, Delete Fram project Where Pnumber = 10: Delete From Department Where Duumber =5; Nole, tor rum eich exception, cominent on the ones that you we not testing Erample: SET SERVEROUIPU ON; DECL.ARE exectaployec Ak EXCEPTION: PRAGMA EXCEPTION_INIT( or_enployee_A, 2,2291). a deparment be EXCHPTION: PRAGMA EXCEPTION INIT (ex departiset ,pk,2292 ); ex projed values EXCEPTION. BEGIN UPDNTE Euployee SET Deio 7 WHERE Sin2=123456789. - DAitite FROM Doparmere WHERE Dumaber =5. - IVSERT INTO Piojeet VALUES(Compueer Sottwae, 1: Tepelo, '17), - BSERT NTO Emoployee VAL,UES (Laura, BS. Tackan', 'L23456789; 10_datct 0L.09 1955 , EXCEPTION WHAN ex cmiploree Ak THEN DAMS OUTPUTPUT. I INEE Foreigs key valse eitered has no cortesposing grimary key value 7). Whink ex drpatmes pl IHEN DBMS O OUPPUT PUT L.INE(Record reettina a primary key the iw a foreign kry in another table. ). DBMS OUTPUT PUT I.INE[Delee the recondh that conctin the foreign key that neference the ex department pk EXCEPITON PRAGMA EXCEPIIOX INIT (ex departnent pk:-2292). ex_ptoject_valses EXCEPTtoN BEGEV UPDATE Emplovee SET Doo a 7 WharE 5m=12446789. - DELEIE FROM Depurtisent thatara Daumber =9, - DSERI DNIO Projoce VALUPSgCoapeter Sofw arc, '1. Tupelo, 17). 'menidifyyy?), 731 Lamar, Orfand, MS, Mr, 3000000,133 (45555: 97) IXCEPIION WhibNex employet 0 THEN DBMS OUIPUTPUT LINE (Foecign key value marted has no cernesponding frimary key value.). WHEN ex depentment pk THFN DBMS OUTPUTPUT L. INE(Recond coeitans a primary key that is a foreign key in another table.). DBMS OUTPUT PUT LDE Deicee the rfoobs that contain the foreim kegt thit reference the primey key.? END

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!