Cascade vs No action

.docx

School

University of South Florida *

*We aren’t endorsed by this school

Course

4220

Subject

Health Science

Date

Dec 6, 2023

Type

docx

Pages

2

Uploaded by MagistrateNightingaleMaster501

Report
| -ldelete patient Lwher‘e patientID = '4' 0% ~ gi Messages Msg 547, Level 16, State 0, Line 14 The [DELETE statement conflicted with the |REFERENCE constraint "EK Event Patient®. The conflict occurred in database "Hospital", The statément has been terminated. Completion time: 2023-10-01T10:41:00.3774506-04:00 FK_Event_Nurse Editing properties for existing relationship. FK_Event_Patient v (General) Check Existing Data (Yes > Tables And Columns v Identity (Name) FK_Event_Patient Description v Table Designer Enforce For Replicatic Yes Enforce Foreign Key Yes v INSERT And UPDATE Delete Rule No Action v Update Rule Add Delete Set Null
100% ~ FH Results Efi Messages eventD eventType date tme patientD nurselD 110 NuLL NULL NULL 4 3 2 111 NULL NULL NULL 5 4 3 112 NULL NULL NULL 6 5 4 114 NULL NULL NULL 8 9 5 115 NULL NULL NULL 9 10 6 116 NULL NULL NULL 10 1 , 7 17 NULL NULL NULL 11 12 -ldelete patient 8 118 NULL NULL NULL 12 13 Lwher‘e patientID = '7° FK_Event_Nurse Editing properties for existing relationship. FK_Event_Patient v (General) Check Existing Data (Yes > Tables And Columns v Identity (Name) FK_Event_Patient Description v Table Designer Enforce For Replicatic Yes Enforce Foreign Key Yes v INSERT And UPDATE elete Rule Cascade N ‘ Update Rule No Action AdA Nelata
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help