Determine the relationships among the four entities in Figure 7-15. List primary keys for each entity 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.

Transcribed Image Text:

TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorlD, StudentID, StartDate, EndDate) TutorID CertDate Status 1/05/2008 Active 1/05/2008 Temp Stop 1/05/2008 Dropped 5/22/2008 Active 5/22/2008 Active 5/22/2008 Temp Stop 5/22/2008 Active 100 MatchID TutorID StudentID StartDate EndDate 101 3000 1/10/2008 100 102 103 101 3001 1/15/2008 5/15/2008 104 3002 2/10/2008 3003 5/28/2008 3 102 3/01/2008 105 106 106 3004 6/01/2008 103 6/15/2008 STUDENT (StudentID, Read) 3005 6/01/2008 3006 6/01/2008 104 6/28/2008 104 StudentID Read 3000 2.3 3001 5.6 3002 1.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) 3003 3.3 Month 1 6/08 MatchID Hours Lessons 3004 2.7 4 3005 4.8 4| 6/08 8. 3006 7.8 5 6/08 4 4 3007 1.5 4 7/08 10 7/08 4