TUTOR (TutorlD, CertDate, Status) MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) TutorID CertDate Status 1/05/2015 Active 1/05/2015 Temp Stop 100 MatchID TutorID StudentID StartDate...

Determine the relationships among the four relations in Figure 7-17. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain referential integrity. Pay particular attention to the data contained in TUTOR REPORTS when you set up its primary key.

Extracted text: TUTOR (TutorlD, CertDate, Status) MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) TutorID CertDate Status 1/05/2015 Active 1/05/2015 Temp Stop 100 MatchID TutorID StudentID StartDate EndDate 101 3000 1/10/2015 1 100 102 1/05/2015 Dropped 103 5/22/2015 Active 3001 1/15/2015 101 5/15/2015 104 5/22/2015 Active 3 102 3002 2/10/2015 3/01/2015 105 5/22/2015 Temp Stop 4 106 3003 5/28/2015 106 5/22/2015 Active 3004 6/01/2015 3005 6/01/2015 5 103 6/15/2015 STUDENT (StudentID, Read) 6 104 6/28/2015 StudentID Read 7 104 3006 | 6/01/2015 3000 2.3 3001 5.6 3002 1.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) 3003 3.3 MatchID Month Hours Lessons 3004 2.7 6/15 8 4 3005 4.8 4 6/15 6 3006 7.8 5 6/15 4 4 3007 1.5 4| 7/15 10 5 1 7/15 4 2 20 JALaite SOLaueri voSven he fellowine ovestiong - 26 JAbora de vou think etudont and uto information suab 9:51 PM 5/1/2021