Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Hello, I would appreciate any help on this question!

image text in transcribed
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 July

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Mathematics questions

Question

Who do you consider family?

Answered: 1 week ago