3- Create a trigger OvrPatient that will guarantee any time the patient cancer type is updated...

Transcribed Image Text:

3- Create a trigger OvrPatient that will guarantee any time the patient cancer type is updated if complication is infection and complication mod is wound infection the trigger writes the following message to the output window. ***ATTENTION *** ATTENTION*** PLCO ID: Cancer Type: Study Year: Complication days: Test it with: update OVARIAN_MED_COMP set CANCTYPE = 1 where PLCO_ID = 'A-108809-7';/ Output should look like: ***ATTENTION PLCO_ID: Cancer Type: Study Year: Test it with: *** ATTENTION*** 2 Complication days: 844 A-108809-7 Ovarian Cancer Output should look like: update OVARIAN_MED_COMP set CANCTYPE = 2 where PLCO_ID = 'T-121744-8';/ ***ATTENTION *** ATTENTION*** PLCO_ID: Cancer Type: Study Year: T-121744-8 Peritoneal Cancer 6 Complication days: 1859 3- Create a trigger OvrPatient that will guarantee any time the patient cancer type is updated if complication is infection and complication mod is wound infection the trigger writes the following message to the output window. ***ATTENTION *** ATTENTION*** PLCO ID: Cancer Type: Study Year: Complication days: Test it with: update OVARIAN_MED_COMP set CANCTYPE = 1 where PLCO_ID = 'A-108809-7';/ Output should look like: ***ATTENTION PLCO_ID: Cancer Type: Study Year: Test it with: *** ATTENTION*** 2 Complication days: 844 A-108809-7 Ovarian Cancer Output should look like: update OVARIAN_MED_COMP set CANCTYPE = 2 where PLCO_ID = 'T-121744-8';/ ***ATTENTION *** ATTENTION*** PLCO_ID: Cancer Type: Study Year: T-121744-8 Peritoneal Cancer 6 Complication days: 1859

Answer rating: 100% (QA)

To create a trigger in a SQL database that will generate a message when certain conditions are met y... View the full answer