SQL:

.6. Determine the relationships among the four entities in Figure 7-15. List primary keys for each entity and any foreign keys necessary to establish the relationships and maintain referential integrity. Pay particular attention to the data contained in TUT.OR REPORTS when you set up its primary key.

7. Write the SQL command to add MATH SCORE to the STUDENT table.

8. Write the SQL command to add SUBJECT to TUT.OR. The only values allowed for SUBJECT will be Reading, Math, and ESL.

9. What do you need to do if a tut.or signs up and wants to tut0r in both reading and math? Draw the new ERD and write any SQL statements that would be needed to handle this development.

TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TuterID, StudentID, StartDate, EndDate) MatchiD 1 TurD 100 EndDate Studenti StartDate 3000 1/10/2008 TutorID 100 101 102 103 104 105 106 CertDate Status 1/05/2008 Active 1/05/2008 Temp Stop 1/05/2008 Dropped 5/22/2008 Active 5/22/2008 Active 5/22/2008 Temp Stop 5/22/2008 Active 2 101 102 3001 1/15/2008 3002 2/10/2008 3003 5/28/2008 5/15/2008 3/01/2008 3 4 106 5 STUDENT (StudentID, Read) 103 104 104 6 30046/01/2008 3005 6/01/2008 3006 6/01/2008 6/15/2008 6/28/2008 Read 7 2.3 StudentID 3000 3001 3002 3003 3004 3005 3006 3007 5.6 1.3 3.3 2.7 4.8 TUTOR REPORT (MatchID, Month, Hours, Lessons) MatchiD Month Hours Lessons 16/08 8 4 6/08 56/08 4 7/08 1 7/08 4 2 4 8 6 7.8 4 4 1.5 10 5