Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I would appreciate any help on this question! TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorID, StudentID, TutorID CertDate Status StartDate, EndDate) 100 1/05/2015
Hello, I would appreciate any help on this question!
TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorID, StudentID, TutorID CertDate Status StartDate, EndDate) 100 1/05/2015 Active MatchID TutorID StudentID StartData EndDate 101 1/05/2015 Temp Stop 100 3000 1/10/2015 102 1/05/2015 Dropped 103 5/22/2015 Active 2 101 3001 1/15/2015 5/15/2015 104 5/22/2015 Active 102 3002 2/10/2015 3/01/2015 105 6/22/2015 Temp Stop 4 106 3003 5/28/2015 106 5/22/2015 Active 103 3004 6/01/2015 6/15/2015 STUDENT (StudentID, Read) 6 104 3005 6/01/2015 6/28/2015 StudentID Read 7 104 3006 6/01/2015 3000 2.3 3001 5.6 3002 1.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) 300% 3.3 MatchID Month Hours Lessons 3004 2.7 6/15 8 3005 4.8 4 6/15 8 6 3006 7.8 5 6/15 4 3007 1.5 4 7/15 10 7/15 4 7-31. Determine the relationships among the four relations in Figure 7-17. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain referential integrity. Pay particular attention to the data contained in TUTOR REPORTS when you set up its primary key. 7-32. Write the SQL command to add column MATH SCORE to the STUDENT table. 7-33. Write the SQL command to add column SUBJECT to TUTOR. The only values allowed for SUBJECT will be Reading, Math, and ESL. 7-34. What do you need to do if a tutor signs up and wants to tutor in both reading and math? Draw the new ERD, create new relations, and write any SQL statements that would be needed to handle this development. 7-35. Write the SQL command to find any tutors who have not submitted a report for JulyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started