Question: What is the average Read score for all students? What are the minimum and maximum Read scores? Based on the relations shown in Figure 6-12.
What is the average Read score for all students? What are the minimum and maximum Read scores?
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.53 Rating (160 Votes )
There are 3 Steps involved in it
a SELECT AVGRead F... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
613-CS-DB (1804).docx
120 KBs Word File
