Create another trigger OvrPatient2 that will guarantee any time the patients' procedure type is updated (or have a new patient) if the procedure is diagnostic, the trigger updates the Quarrian Track table with PLCO_ID, old procedure type, new procedure type, age, and number of days from randomization to completion date.

 

Transcribed Image Text:

Ovarian Track PLCO ID Old procedure type New procedure type Test it with: Test it with: update ovarian diagnostic set pros num = 12 where PLCO_ID= B-079326-7':/ update gvarian diagnostic set pros numg=21 where PLCO ID="I-155698-7":/ 11 Age Number of days Ovarian Track PLCO ID Old procedure type New procedure type Test it with: Test it with: update ovarian diagnostic set pros num = 12 where PLCO_ID= B-079326-7':/ update gvarian diagnostic set pros numg=21 where PLCO ID="I-155698-7":/ 11 Age Number of days

Answer rating: 100% (QA)

To create a trigger named OvrPatient2 that updates the Quarrian Track table whenever a patients procedure type is updated to diagnostic or a new patie... View the full answer