Question: Delete the record from table tuto with TutorID=104. Examine data in table MATCH_HISTORY. You will find that all records for TutorID =104 have also been

Delete the record from table tuto with TutorID=104. Examine data in table MATCH_HISTORY. You will find that all records for TutorID =104 have also been dropped. We have therefore lost the history about tutoring students with Student ID 6 and 7. Why is that the case? Is there a way for us to prevent deleting records in table tuto or table STUDENT while there are matching records in MATCH_HISTORY?
FIGURE 6-12 Adult literacy program (for Problems and Exercises 6-45 through 6-53) TUTOR TutorID, CertDate, Status) STUDENT (StudentlD, Read) TutorID Status 100 1/05/2015 101 1/05/2015 102 1/05/2015 103 5/22/2015 104 5/22/2015 105 5/22/2015 106 5/22/2015 3000 3001 3002 3003 3004 2.3 5.6 1.3 3.3 2.7 4.8 7.8 1.5 Temp Stop Temp Stop 3006 3007 MATCH HISTORY (MatchID, TutoriD, StudentlD, StartDate, EndDate) MatchID TutorlD 100 1/10/2015 101 102 106 1/15/2015 3002 2/10/2015 3003 5/28/2015 5/15/2015 3/01/2015 103 104 104 3004 6/01/2015 3005 6/01/2015 3006 6/01/2015 6/15/2015 6/28/2015
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
