Create in SQL Database

FIGURE 6-71 Adult literacy program (for Problems and Exercises 10 through 15) Chapter 6 Introduction to SO TUTOR (Tutorid, CertDate, Status) STUDENT (StudentID, Read) Tutorld CertDate Status StudentID Read 100 1/05/2008 Active 3000 2.3 101 1/05/2008 Temp Stop 3001 5.6 102 1/05/2008 Dropped 3002 1.3 103 5/22/2008 Active 3003 3.3 104 5/22/2008 Active 3004 2.7 105 5/22/2008 3005 4.8 Temp Stop 106 5/22/2008 3006 7.8 Active 3007 1.5 MATCH HISTORY (MatchID, TutorID, Studenti, StartDate, EndDate) MatchID TutorID StudentID StartDate EndDate 1 100 3000 1/10/2008 101 3001 1/15/2008 5/15/2008 N 3002 102 2/10/2008 3/01/2008 3 106 3003 5/28/2008 4 3004 103 6/01/2008 6/15/2008 5 3005 6/01/2008 6/28/2008 104 6 3006 6/01/2008 104 7 Problems and Exercises 10 through 15 are based on the relations shown in Figure 6-11. The database tracks an adult literacy program. Tutors an assessment interview that results in a report for the tutor and a complete a certification class offered by the agency. Students complete 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 tutor- ing 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. 10. How many tutors have a status of Temp Stop? Which tutors are active? 11. What are the TutorIDs for tutors who have not yet tutored anyone? 12. How many students were matched with someone in the first five months of the year? 13. Which student has the highest Read score? 14. How long had each student studied in the adult literacy program? 15. What is the average length of time a student stayed (or has stayed) in the program? 7