Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Moving Objects Databases

Authors: Ralf Hartmut Güting, Markus Schneider

1st Edition

0120887991, 978-0120887996

More Books

Students also viewed these Databases questions

Question

Discuss the techniques of job analysis.

Answered: 1 week ago

Question

How do we do subnetting in IPv6?Explain with a suitable example.

Answered: 1 week ago

Question

Explain the guideline for job description.

Answered: 1 week ago

Question

What is job description ? State the uses of job description.

Answered: 1 week ago

Question

What are the objectives of job evaluation ?

Answered: 1 week ago

Question

Provide examples of Dimensional Tables.

Answered: 1 week ago