Question: How many tutors have a status of Temp Stop? Which tutors are active? Based on the relations shown in Figure 6-12. The database tracks an
How many tutors have a status of Temp Stop? Which tutors are active?
Based on the relations shown in Figure 6-12. The database tracks an adult literacy program. Tutors complete a certification class offered by the agency. Students complete an assessment interview that results in a report for the tutor and a recorded Read score. When matched with a student, a tutor meets with the student for one to four hours per week. Some students work with the same tutor for years, some for less than a month. Other students change tutors if their learning style does not match the tutor's tutoring style. Many tutors are retired and are available to tutor only part of the year. Tutor status is recorded as Active, Temp Stop, or Dropped.

TUTOR (TutorID, CertDate, Status) STUDENT (StudentID, Read) StudentID Read TutorID CertDate Status 3000 2.3 Active 100 1/05/2015 3001 5.6 101 1/05/2015 Temp Stop 3002 1.3 102 1/05/2015 Dropped 3003 3.3 103 5/22/2015 Active 3004 2.7 104 5/22/2015 Active 3005 4.8 105 5/22/2015 Temp Stop 3006 7.8 106 5/22/2015 Active 3007 1.5 MATCH HISTORY (MatchID, TutorlID, StudentID, StartDate, EndDate) StudentID MatchID TutorID StartDate EndDate 100 3000 1/10/2015 1/15/2015 3001 101 5/15/2015 3002 3 102 2/10/2015 3/01/2015 5/28/2015 4 106 3003 103 5 3004 6/01/2015 6/15/2015 6. 104 3005 6/01/2015 6/28/2015 3006 104 6/01/2015
Step by Step Solution
3.42 Rating (168 Votes )
There are 3 Steps involved in it
a SELECT COUNT TutorID A... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
613-CS-DB (1803).docx
120 KBs Word File
