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. TUTOR (TutorlD, CertDate, Status)MATCH HISTORY (MatchID, TutorID, StudentID,StartDate, EndDate)TutorIDCertDateStatus1/05/2015 Active1/05/2015 Temp Stop100MatchIDTutorIDStudentIDStartDateEndDate1013000 1/10/201511001021/05/2015 Dropped1035/22/2015 Active3001 1/15/20151015/15/20151045/22/2015 Active31023002 2/10/20153/01/20151055/22/2015 Temp Stop41063003 5/28/20151065/22/2015 Active3004 6/01/20153005 6/01/201551036/15/2015STUDENT (StudentID, Read)61046/28/2015StudentIDRead71043006 | 6/01/201530002.330015.630021.3TUTOR REPORT (MatchID, Month, Hours, Lessons)30033.3MatchIDMonthHoursLessons30042.76/158430054.846/15630067.856/154430071.54| 7/1510517/154220 JALaite SOLauerivoSven he fellowine ovestiong- 26 JAbora de vou think etudont and uto information suab9:51 PM5/1/2021

Teacher table:- Teacher table contains the teacher information. Match history table contains the…

Answered: TUTOR (TutorlD, CertDate, Status) MATCH…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

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.

TUTOR (TutorlD, CertDate, Status)
MATCH HISTORY (MatchID, TutorID, StudentID,
StartDate, EndDate)
TutorID
CertDate
Status
1/05/2015 Active
1/05/2015 Temp Stop
100
MatchID
TutorID
StudentID
StartDate
EndDate
101
3000 1/10/2015
1
100
102
1/05/2015 Dropped
103
5/22/2015 Active
3001 1/15/2015
101
5/15/2015
104
5/22/2015 Active
3
102
3002 2/10/2015
3/01/2015
105
5/22/2015 Temp Stop
4
106
3003 5/28/2015
106
5/22/2015 Active
3004 6/01/2015
3005 6/01/2015
5
103
6/15/2015
STUDENT (StudentID, Read)
6
104
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)
3003
3.3
MatchID
Month
Hours
Lessons
3004
2.7
6/15
8
4
3005
4.8
4
6/15
6
3006
7.8
5
6/15
4
4
3007
1.5
4| 7/15
10
5
1
7/15
4
2
20 JALaite SOLaueri
voSven he fellowine ovestiong
- 26 JAbora de vou think etudont and uto information suab
9:51 PM
5/1/2021

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions