Mysql queries.
TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorID, Studenti, StartDate, EndDate) Matchid EndDate TutorID 100 StudentID StartDate 30001/10/2008 TutorID 100 101 102 103 104 105 106 CertDate 1/05/2008 1/05/2008 1/05/2008 5/22/2008 5/22/2008 5/22/2008 5/22/2008 Status Active Temp Stop Dropped Active Active Temp Stop Active 101 102 106 3001 1/15/2008 30022/10/2008 3003 5/28/2008 5/15/2008 3/01/2008 5 103 STUDENT (StudentID, Read) 6/15/2008 6/28/2008 6 30046/01/2008 30056/01/2008 3006 6/01/2008 104 104 7 StudentID 3000 3001 3002 3003 3004 3005 3006 3007 Read 2.3 5.6 1.3 3.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) MatchID Month Hours Lessons 16/08 46/08 56/08 7.8 1.5 4 7/08 17/08 Show transcribed image text TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorID, Studenti, StartDate, EndDate) Matchid EndDate TutorID 100 StudentID StartDate 30001/10/2008 TutorID 100 101 102 103 104 105 106 CertDate 1/05/2008 1/05/2008 1/05/2008 5/22/2008 5/22/2008 5/22/2008 5/22/2008 Status Active Temp Stop Dropped Active Active Temp Stop Active 101 102 106 3001 1/15/2008 30022/10/2008 3003 5/28/2008 5/15/2008 3/01/2008 5 103 STUDENT (StudentID, Read) 6/15/2008 6/28/2008 6 30046/01/2008 30056/01/2008 3006 6/01/2008 104 104 7 StudentID 3000 3001 3002 3003 3004 3005 3006 3007 Read 2.3 5.6 1.3 3.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) MatchID Month Hours Lessons 16/08 46/08 56/08 7.8 1.5 4 7/08 17/08
Expert Answer
Answer to TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorID, Studenti, StartDate, EndDate) Matchid EndDate TutorID…