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

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

1 Expert Approved Answer
Step: 1 Unlock

a SELECT AVGRead F... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1804).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!