Question: 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

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 TUTOR REPORTS when you set up its primary key.

TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorlD, StudentID, StartDate, EndDate) TutorID CertDate Statu

TUTOR (TutorID, CertDate, Status) MATCH HISTORY (MatchID, TutorlD, StudentID, StartDate, EndDate) TutorID 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 100 MatchID TutorID StudentID StartDate EndDate 101 3000 1/10/2008 100 102 103 101 3001 1/15/2008 5/15/2008 104 3002 2/10/2008 3003 5/28/2008 3 102 3/01/2008 105 106 106 3004 6/01/2008 103 6/15/2008 STUDENT (StudentID, Read) 3005 6/01/2008 3006 6/01/2008 104 6/28/2008 104 StudentID Read 3000 2.3 3001 5.6 3002 1.3 TUTOR REPORT (MatchID, Month, Hours, Lessons) 3003 3.3 Month 1 6/08 MatchID Hours Lessons 3004 2.7 4 3005 4.8 4| 6/08 8. 3006 7.8 5 6/08 4 4 3007 1.5 4 7/08 10 7/08 4

Step by Step Solution

★★★★★

3.44 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Tutor Primary key TutorID Foreign key none Student Primary key StudentID Foreign key no... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Essentials Database Management Questions!

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...

1. To what events must the SBRU booking system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. Be sure to consider only...

1. Explain the advantages of locating the PRIDE database in the clouded. Flores and his partners could place it on one of their own servers in the practice. Give reasons why it would be unwise for...

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...

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...

. Determine the relationships among the four relations in Figure 6-16. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain referential...

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...

Determine the relationships among the four relations in the following figure. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain...

Business problem Our company does car rental business and has several locations with different addresses (address consist of street or rural route with the number, city, state and zip code). The cars...

An insurance company will insure a $50,000 diamond for its full value against theft at a premium of $400 per year. Suppose that the probability that the diamond will be stolen is .005. and let x...

What distinguishes dynamic programming from other divide-and-conquer algorithms? Select the correct answer: Solutions to sub-problems can be computed in parallel. The solution is implemented...

Including REITs in a portfolio containing S&P 5 0 0 securities produces diversification benefits. Why? Real estate investment returns do not change much from one year to another. Real estate...

What qualities make an individual an effective ambassador for a cause? How can essential skills be practiced?

The ALU supported set on less than (slt) using just the sign bit of the adder. Lets try a set on less than operation using the values -7 ten and 6 ten . To make it simpler to follow the example, lets...

A simple check for overfl ow during addition is to see if the CarryIn to the most significant bit is not the same as the CarryOut of the most significant bit. Prove that this check is the same as in...

Rewrite the equations on page B-44 for a carry-lookahead logic for a 16-bit adder using a new notation. First, use the names for the CarryIn signals of the individual bits of the adder. That is, use...

What does the highest point in the frequency polygon show? A- it shows where most of the participants are clustered B- it shows where the least of the participants are clustered C-it shows where the...

open this Microsoft Word document. Using your knowledge of effective writing and the tips on page 147 for evaluating the work of other writers, evaluate this message. After you set Microsoft Word to...

Assessed Exercises Sheet 1 Al.1. Use the substitution x = a sinh u to work out the integral (a? + 12)1/2 dec. [4] A1.2. (i) Show that the Laplace transform of f(x) = x is 2. (ii) Show by induction...