Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started