Book: Modern Database Management-10th Edition

a

Chapter 7, Problem 40PE Bookmark Show all steps: ON Problems and are based on Figure 7-17. This problem set continues from Chapter 6, Problems and Exercises 6-45 through 6-53, which were based on Figure 6-12. FIGURE 7-17 Adult literacy program (for Problems and Exercises 7-31-7-41) TUTOR (TutoriD, CertDate, Status) Tutorid MATCH HISTORY (MatchID, Tutorid, Studenti, StartDate, EndDate) Match Tutorld Studenti StartDate 3000 1/10/2015 EndDate 100 101 102 100 CertDate Status 1/05/2015 Active 1/05/2015 Temp Stop 1/05/2015 Dropped 5/22/2015 Active 5/22/2015 Active 5/22/2015 Temp Stop 5/22/2015 Active 103 2 101 104 3 102 3001 1/15/2015 5/15/2015 3002 2/10/2015 3/01/2015 3003 5/28/2015 105 106 4 106 103 Noon 104 3004 6/01/2015 6/15/2015 3005 6/01/2015 6/28/2015 3006 6/01/2015 104 STUDENT (Studenti, Read) StudentID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 4.8 3006 7.8 3007 1.5 3005 TUTOR REPORT (MatchID, Month, Hours, Lessons) MatchID Month Hours Lessons 1 6/15 8 4 6/15 8 6 5 6/15 4 7/15 10 1 7/15 4 2 4 4 5 Which tutors, by name, are available to tutor? Write the SQL command. Chapter 7, Problem 40PE Bookmark Show all steps: ON Problems and are based on Figure 7-17. This problem set continues from Chapter 6, Problems and Exercises 6-45 through 6-53, which were based on Figure 6-12. FIGURE 7-17 Adult literacy program (for Problems and Exercises 7-31-7-41) TUTOR (TutoriD, CertDate, Status) Tutorid MATCH HISTORY (MatchID, Tutorid, Studenti, StartDate, EndDate) Match Tutorld Studenti StartDate 3000 1/10/2015 EndDate 100 101 102 100 CertDate Status 1/05/2015 Active 1/05/2015 Temp Stop 1/05/2015 Dropped 5/22/2015 Active 5/22/2015 Active 5/22/2015 Temp Stop 5/22/2015 Active 103 2 101 104 3 102 3001 1/15/2015 5/15/2015 3002 2/10/2015 3/01/2015 3003 5/28/2015 105 106 4 106 103 Noon 104 3004 6/01/2015 6/15/2015 3005 6/01/2015 6/28/2015 3006 6/01/2015 104 STUDENT (Studenti, Read) StudentID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 4.8 3006 7.8 3007 1.5 3005 TUTOR REPORT (MatchID, Month, Hours, Lessons) MatchID Month Hours Lessons 1 6/15 8 4 6/15 8 6 5 6/15 4 7/15 10 1 7/15 4 2 4 4 5 Which tutors, by name, are available to tutor? Write the SQL command